What is the best way to do database connection pooling using JSPs?

You have at least three choices:

A) Use the database pooling services built into JDBC 2.0-compliant drivers.

B) Use an application server such as WebLogic or WebSphere, which provides these services.

C) Write your own database pooling classes (it's really not that complicated).