Java Doc for DBPool.java in  » EJB-Server-resin-3.1.5 » resin » com » caucho » sql » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Like JDBC 2.0 pooling, DBPool returns a wrapped Connection. Applications can use that connection just like an unpooled connection. It is more important than ever to close() the connection, because the close returns the connection to the connection pool.

Example using DataSource JNDI style (recommended)

 Context env = (Context) new InitialContext().lookup("java:comp/env");
 DataSource pool = (DataSource) env.lookup("jdbc/test");
 Connection conn = pool.getConnection();
 try {
 ... // normal connection stuff
 } finally {
 conn.close();
 }
 

Configuration

 <database name='jdbc/test'>
 <init>
 <driver>postgresql.Driver</driver>
 <url>jdbc:postgresql://localhost/test</url>
 <user>ferg</user>
 <password>foobar</password>
 </init>
 </database>
 

Pool limits and timeouts

Connections will only stay in the pool for about 5 seconds. After that they will be removed and closed. This reduces the load on the DB and also protects against the database dropping old connections.