Connection Pooling in tomcat

[Glenny Dsilva]

I am using servlets tomcat 5.0 webserver and mysql as database in my project.

I want to use connection pooling.

If i want 50 active connections in my application.

How do i configure it in my web application.

Can someone explain or give me a url to configure it.

[Paul Sturrock]

Presuming you are happy using Tomcat's default connection pool (DBCP) you just configure your DataSource to use up to 50 connections with the "maxActive" parameter. If you read through the Tomcat documentation, particularaly the part about JNDI resources, you'll see how its done.

[Ben Souther]

Glenny,

There is a forum devoted to Apache Tomcat on this site.
Your question will probably get better responses there.

Here is the documentation Paul mentioned:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources-howto.html