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 16:57:43 GMT
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






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