Two Laptop Bag*
The moose likes JDBC and the fly likes Difference between app server connection pooling and the driver supported pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Difference between app server connection pooling and the driver supported pool" Watch "Difference between app server connection pooling and the driver supported pool" New topic
Author

Difference between app server connection pooling and the driver supported pool

Murali Mohan
Ranch Hand

Joined: Jun 14, 2001
Posts: 47
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
Ranch Hand

Joined: Mar 08, 2004
Posts: 57
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/
 
jQuery in Action, 2nd edition
 
subject: Difference between app server connection pooling and the driver supported pool