tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Christiansen" <Nathan_Christian...@tni.com>
Subject RE: Urgent help, please!Best practices using Connection Pool
Date Wed, 08 Oct 2003 23:23:11 GMT
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:Jose.Euclides@rj.previdenciasocial.gov.br]
Sent: Wednesday, October 08, 2003 5:19 PM
To: 'tomcat-user@jakarta.apache.org'
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message