Usually you should return every connection to your Persistence mechanism, you cannot close the connection, because if do that other process won´t use it.
> ---------- > De: Jose Euclides da Silva Junior - > DATAPREVRJ[SMTP:[EMAIL PROTECTED] > Responder: Tomcat Users List > Enviada: quinta-feira, 9 de outubro de 2003 10:26 > Para: '[EMAIL PROTECTED]' > Assunto: Urgent help, please!Best practices using Connection Pool > > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >