The connection pooling does not depends on which webserver you are using. So any CP class should work fine in Tomcat/Apache and in NT or Weblogic or whatever. A con pool class manages your DB connections and some BD vendors provide you with a connectionPool class with their driver. You can learn to code your own class here: http://developer.java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html where you can also have access to the JDCConnectionPool.java code. HTH
shekarasankaran, JavaRanch has a naming policy which is strictly enforced. Please read the policy and change your display name if you wish to continue posting here. You can change your name: here This topic is more appropriate for the Apache/Tomcat forum. I will move it there for you.
Originally posted by Juanjo Bazan: The connection pooling does not depends on which webserver you are using. So any CP class should work fine in Tomcat/Apache and in NT or Weblogic or whatever...
Tomcat versions 4.0 and upwards are already equipped with connection pooling through the Jakarta DBCP Commons component. If you are using older versions, you have no recourse but to use third party implementations or to write your own. A good one is PoolMan, although official word from its author, PS Neville, says that development has been stopped. Another is DBConnectionBroker. If you plan to write your own , here's another resource, courtesy of Marty Hall's Core Servlets and JavaServer Pages: Chapter 18: JDBC and Database Connection Pooling Hope that helps. Ex Animo Java! -- Val [ August 09, 2002: Message edited by: Val Pecaoco ]
"Knowledge is power, but enthusiasm is the key." -- Lavern Barn