tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edson Alves Pereira <eapere...@panamericano.com.br>
Subject RE: Urgent help, please!Best practices using Connection Pool
Date Thu, 09 Oct 2003 13:33:32 GMT
	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@rj.previdenciasocial.gov.br]
> Responder: 	Tomcat Users List
> Enviada: 	quinta-feira, 9 de outubro de 2003 10:26
> Para: 	'tomcat-user@jakarta.apache.org'
> 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@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message