public static void main(String[] argv) {
try {
String dmds_name = null;
String cpds_name = null;
String pbds_name = null;
if (argv.length == 3) {
dmds_name = argv[0];
cpds_name = argv[1];
pbds_name = argv[2];
} else usage();
InitialContext ctx = new InitialContext();
DataSource dmds = (DataSource) ctx.lookup(dmds_name);
dmds.getConnection().close();
System.out.println(
"DriverManagerDataSource " + dmds_name + " sucessfully looked up and checked.");
ConnectionPoolDataSource cpds = (ConnectionPoolDataSource) ctx.lookup(cpds_name);
cpds.getPooledConnection().close();
System.out.println(
"ConnectionPoolDataSource " + cpds_name + " sucessfully looked up and checked.");
DataSource pbds = (DataSource) ctx.lookup(pbds_name);
pbds.getConnection().close();
System.out.println(
"PoolBackedDataSource " + pbds_name + " sucessfully looked up and checked.");
} catch (Exception e) {
e.printStackTrace();
}
}
static void drop(DataSource ds) throws SQLException {
Connection con = null;
Statement stmt = null;
try {
con = ds.getConnection();
stmt = con.createStatement();
stmt.executeUpdate("DROP TABLE TRSS_TABLE");
} finally {
StatementUtils.attemptClose(stmt);
ConnectionUtils.attemptClose(con);
}
}
static void create(DataSource ds) throws SQLException {
Connection con = null;
Statement stmt = null;
try {
con = ds.getConnection();
stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE TRSS_TABLE ( a_col VARCHAR(16) )");
} finally {
StatementUtils.attemptClose(stmt);
ConnectionUtils.attemptClose(con);
}
}
static void doSomething(DataSource ds) throws SQLException {
Connection con = null;
Statement stmt = null;
try {
con = ds.getConnection();
stmt = con.createStatement();
int i =
stmt.executeUpdate(
"INSERT INTO TRSS_TABLE VALUES ('" + System.currentTimeMillis() + "')");
if (i != 1) throw new SQLException("Insert failed somehow strange!");
} finally {
StatementUtils.attemptClose(stmt);
ConnectionUtils.attemptClose(con);
}
}