About connection pooling



Hi,

Could somebody explain the connection pooling for me a bit more? Or to be specific, how do I obtain the correct connection pooling for my servlet.

I am using jTDS (1.1) driver to connect MS SQL Server and Apache Tomcat (5.5) to keep my servlet serving and I use Jakarta redirector for IIS to redirect servlet requests to Tomcat. The actual app is an Applet.

I have been aware of connection pooling and the benefits of pooled connections. Every time I read about this subject I get a different answer(!). So here is what I have found out: (the question mark stands for your correction if I am wrong :)

1. jTDS (and jdbc) has a builtin connection pooling (?)
2. Apache Tomcat has a builtin connection pooling (?)
3. and there are other classes that I can use to make my servlet to pool connections (eg. DBPool, DBCP, JNDI (?))?


Which of these pools should I use?

Cheers,
Mika
.