Difference between app server connection pooling and the driver supported pool

[Murali Mohan]

Hi all,
How to get connection pooling with out application server and tomcat also?
I read some where, JDBC2.0 provides 2 interfaces javax.sql.ConnectionPoolDataSource and javax.sql.PooledConnection. If my driver supports these interfaces can I get connection pooling by using these interfaces? Should I need any other packages?
Is the Oracle Thin driver implementing these 2 interfaces currently?
What is the difference between using app server connection pooling and using the driver supported connection pooling?
Regards,
Murali
[ March 10, 2004: Message edited by: Murali Mohan ]

[brad balmer]

Since I'm assuming you don't want to write your own connection pool, there are many free ones out there.
Try taking a look at:
http://jakarta.apache.org/commons/dbcp/