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:Jose.Euclides@(protected)]
> Responder:  Tomcat Users List
> Enviada:  quinta-feira, 9 de outubro de 2003 10:26
> Para:  'tomcat-user@(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: tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail: tomcat-user-help@(protected)
>