c3p0-0.9.5

import java.sql.*; import javax.naming.*; import javax.sql.DataSource; /** * This example shows how to programmatically get and directly use * an unpooled DataSource */ public final class UseJndiDataSource { public static void main(String[] argv) { try { // let a command line arg specify the name we will // lookup our DataSource. String jndiName = argv[0]; // Create an InitialContext, and lookup the DataSource in // the usual way. // // We are using the no-arg version of InitialContext's constructor, // therefore, the jndi environment must be first set via a jndi.properties // file, System properties, or by some other means. InitialContext ctx = new InitialContext(); // acquire the DataSource... this is the only c3p0 specific code here DataSource ds = (DataSource) ctx.lookup( jndiName ); // get hold of a Connection an do stuff, in the usual way Connection con = null; Statement stmt = null; ResultSet rs = null; try { con = ds.getConnection(); stmt = con.createStatement(); rs = stmt.executeQuery("SELECT * FROM foo"); while (rs.next()) System.out.println( rs.getString(1) ); } finally { // i try to be neurotic about ResourceManagement, // explicitly closing each resource // but if you are in the habit of only closing // parent resources (e.g. the Connection) and // letting them close their children, all // c3p0 DataSources will properly deal. attemptClose(rs); attemptClose(stmt); attemptClose(con); } } catch (Exception e) { e.printStackTrace(); } } static void attemptClose(ResultSet o) { try { if (o != null) o.close();} catch (Exception e) { e.printStackTrace();} } static void attemptClose(Statement o) { try { if (o != null) o.close();} catch (Exception e) { e.printStackTrace();} } static void attemptClose(Connection o) { try { if (o != null) o.close();} catch (Exception e) { e.printStackTrace();} } private UseJndiDataSource() {} }