Couldn't build an initial context : " + e);
return null;
}
try {
Object value = ctx.lookup("java:/comp/env/jdbc/abandoned");
out.println("
DataSource lookup");
out.println("
jdbc value : " + value);
out.println("
jdbc class : " + value.getClass().getName());
out.println("
");
if (value instanceof DataSource) {
return (DataSource) value;
}
else {
return null;
}
} catch (NamingException e) {
out.println("
JNDI lookup failed : " + e);
return null;
}
}
private void getConnection1(DataSource ds, JspWriter out) throws Exception {
System.err.println("BEGIN getConnection1()");
out.println("
BEGIN getConnection1()");
Connection conn = ds.getConnection();
System.err.println("conn: " + conn);
out.println("
conn: " + conn);
System.err.println("END getConnection1()");
out.println("
END getConnection1()");
}
private void getConnection2(DataSource ds, JspWriter out) throws Exception {
System.err.println("BEGIN getConnection2()");
out.println("
BEGIN getConnection2()");
Connection conn = ds.getConnection();
System.err.println("conn: " + conn);
out.println("
conn: " + conn);
System.err.println("END getConnection2()");
out.println("
END getConnection2()");
}
private void getConnection3(DataSource ds, JspWriter out) throws Exception {
System.err.println("BEGIN getConnection3()");
out.println("
BEGIN getConnection3()");
Connection conn = ds.getConnection();
System.err.println("conn: " + conn);
out.println("
conn: " + conn);
System.err.println("END getConnection3()");
out.println("
END getConnection3()");
}
]]>
DBCP Abandoned Connection Test
DBCP Abandoned Connection Test
DataSource ds = getDataSource(out);
if (ds != null) {
getConnection1(ds, out);
getConnection2(ds, out);
getConnection3(ds, out);
}
OK