Java Mailing List Archive

http://www.junlu.com/

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

Re: Urgent help, please!Best practices using Connection Pool

Adam Hardy

2003-10-08

Replies:

Hi Jose,
the connection that you are served by your data source is a connection
wrapper where the close method will not really close the connection,
rather it will tell the connection pool that this connection is free and
can be put back in the pool.

HTH
Adam

PS I wouldn't flag your email as "urgent" - I doubt it makes much
difference to how quickly you get an answer, and often it only serves to
put people off from reading your mail at all, simply because it annoys
them that you consider your email should have higher priority for some
reason than everyone else's. As if everyone is sitting around happily
chatting about really non-urgent things. (which they do sometimes, but
mostly not).

On 10/09/2003 01:18 AM Jose Euclides da Silva Junior - DATAPREVRJ wrote:
> Hi,
> i am using DBCP 1.0. My question is simple: since DBCP doesnt create a
> singleton object ( just a data source object), what should i do whenever my
> sql queries are done? Should i close the connection after that? But, if i do
> this, will i loose my connection pool facility, so my next connection time
> will waste more time...
> Thanks in advance,
> Euclides.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail: tomcat-user-help@(protected)
>
>

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


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