tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jose Euclides da Silva Junior - DATAPREVRJ <Jose.Eucli...@rj.previdenciasocial.gov.br>
Subject RES: AW: Urgent help, please!Best practices using Connection Pool
Date Thu, 09 Oct 2003 13:56:14 GMT
Good! Its enough to me! So, i always can use the 'close()' method whenever
the query statement ends since my connection pool will stand 'alive', still.
Of course, my pool wraps the connection object... My email service was down
yesterday...
Thanks at all,
Euclides.

-----Mensagem original-----
De: Adam Hardy [mailto:ahardy.struts@cyberspaceroad.com]
Enviada em: quinta-feira, 9 de outubro de 2003 10:42
Para: Tomcat Users List
Assunto: Re: AW: Urgent help, please!Best practices using Connection
Pool


I think he must be having problems with his email because he send more 
or less the same msg 12 hours ago but didn't respond to any of the replies.

On 10/09/2003 03:27 PM Nitschke Michael wrote:
> I could remember that there was a mail today that answered your question.
> The pool provides an wrapper for the connection object that you receive,
this means you call getConnection and you do not get the real connection
instead you recive an object implementing the Connection functionality with
an altered "close()" method, which does not close/release the connection,
but returns the connection to the pool.
> 
> If it was to short, read the original post in the archives.
> Mike
> 
> -----Urspr√ľngliche Nachricht-----
> Von: Jose Euclides da Silva Junior - DATAPREVRJ
[mailto:Jose.Euclides@rj.previdenciasocial.gov.br] 
> Gesendet: Donnerstag, 09. Oktober 2003 15:27
> An: 'tomcat-user@jakarta.apache.org'
> Betreff: 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
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 

-- 
struts 1.1 + tomcat 5.0.12 + java 1.4.2
Linux 2.4.20 RH9


---------------------------------------------------------------------
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