Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Pooling in Tomcat-Apache

 
shekarasankaran
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any 3rd party vendor who provides connection pooling for Tomcat-Apache
 
Juanjo Bazan
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Matthew Phillips
Ranch Hand
Posts: 2676
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Val Pecaoco
Ranch Hand
Posts: 156
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic