Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

Urgent help, please!Best practices using Connection Pool

Jose Euclides da Silva Junior - DATAPREVRJ

2003-10-09

Replies:

Hi gurus, help me please.
i am using DBCP 1.0 to make connection pool avaiable. My question can be
easy: since DBCP 1.0 doesnt create a singleton object ( just a datasource
object), what should i do whenever my sql queries are done? Should i close
the connection after each sql command is completed? But, if i do this, will
i loose my connection pool facility, so my next sql command will spend more
time since the connection process ( with the database ) would be started
before the sql running. I really need to improve my database response time!
Thanks in advance,
Euclides.


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


©2008 junlu.com - Jax Systems, LLC, U.S.A.