Justin, The DBCP that's bundled with Tomcat as well as most other pools (proxool for one) return a java.sql.Connection implementation class that wraps the actual DB driver java.sql.Connection implementation. Calling close() on the Connection that you got from the pool returns the underlying connection to the pool for reuse.
For DBCP, if you don't call close(), the connection is eventually considered abandoned, and there are a few configuration parameters that affect what happens at that point. http://jakarta.apache.org/commons/dbcp/ for details. -john. -----Original Message----- From: James Neville [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:51 AM To: Tomcat Users List Subject: Re: Connection Pooling Justin, That would all depend on the pooling implementation you're using. Commonly, its pool.free(conn) or pool.freeConnection(conn). Remember *not* to close the connection if you're using connection pooling, as this should be handled by the pool itself. That said.... one of my colleagues mentioned one pooling implementation he used that returned a custom connection object when obtained from the pool (ie not a java.sql Connection object). The close() method on that connection returned it to the pool, but *didn't* actually close it. If you let us know which pooling implementation you're using, it may make things clearer ;) Cheers, James Hart, Justin wrote: >Is there some manner in which a database connection should be returned >to the connection pool, or is that automatic? > > > >Justin > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]