DBCP wraps the connection object. When you call conn.close(); on the connection object given to you by the DataSource.getConnection(); method, it just releases it back into the pool, it dosen't actually close the connection.
-- Nathan Christiansen Tahitian Noni International http://www.tahitiannoni.com -----Original Message----- From: Jose Euclides da Silva Junior - DATAPREVRJ [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 5:19 PM To: '[EMAIL PROTECTED]' Subject: Urgent help, please!Best practices using Connection Pool Hi, i am using DBCP 1.0. My question is simple: since DBCP doesnt create a singleton object ( just a data source object), what should i do whenever my sql queries are done? Should i close the connection after that? But, if i do this, will i loose my connection pool facility, so my next connection time will waste more time... Thanks in advance, Euclides. --------------------------------------------------------------------- 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]