Question on Tomcat db connection pool

[yacanna]

I am using Tomcat database connection pool. In my java class, Do I need to close database connection after I openned the connection and retrieved data from database.

I would appreciate any help on this.

 

[sedj]

Yes.
You should ALWAYS close a db connection.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[alebu]

java.sql.Connection is interface, not a class, so the thing you got from pool is not actually the same what you got directly creating connection. When you call close on connection from pool, pool returns REAL connection to pool, so it become available for further reuse.

 

[sedj]

Thats true, but you should still always close the connection object - pooling does not negate that fact.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk