tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David kerber <dcker...@verizon.net>
Subject Re: Is Connection Pooling still necessary?
Date Thu, 17 Apr 2008 17:29:08 GMT
David kerber wrote:
> Jonathan Mast wrote:
>> I'm developing a webapp that is going to be making frequent DB 
>> operations.
>> I know that DB connections are expensive and that developers pool
>> connections to prevent the overhead of frequent instantiation.  Is this
>> design pattern still necessary?  I ask because I vaguely recall skimming
>> over an article that stated that this design pattern is not needed 
>> anymore
>> with newer versions of Java.
>>
>> Currently, our webapps make infrequent calls to our database and as 
>> such I
>> simply use a static getConnection() method to create new Connections, 
>> which
>> I explicitly close at the end of their use.
>>
>> I realize that our setup, Tomcat 5.5 on Java 1.4.2, will almost 
>> certainly
>> require connection pooling.  But does newer versions of Java obviate 
>> this
>> need?
>>
>> Any pointers to relevant (ie. JDK 1.4.2) tutorials on this topic 
>> would be
>> greatly appreciated.
>>
>> Thanks
>>   
> Partly:  I don't believe you need to handle the connection pooling 
> yourself, because Tomcat and/or the JRE handle it automatically.  I've 
> never done any explicit connection pooling on TC 5.5/Java 1.5, even 
> with some large numbers of simultaneous connections, and it works fine.
>
> D

Looking at these other posts, and the reference Charles posted, it's 
apparent that I've been getting away without using pooling, even though 
I though I was using it...

D



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message