This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JSP and the fly likes package for connection pooling?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "package for connection pooling??" Watch "package for connection pooling??" New topic

package for connection pooling??

mihir maniar
Ranch Hand

Joined: Sep 09, 2003
Posts: 88
please let me know what sort of interfaces or classes to use for connection pooling
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16901

In modern-day appservers, the connection pooling is done by the J2EE container, which constructs a javax.sql.DataSource, from which you get your connection (which MUST be closed after use). You use JNDI to locate the datasource object.

The exact setup varies, so you'll have to read your appserver's documentation.

A Connection obtained via a datasource from a pool behaves exactly like any other Connection except that if you don't close it, it won't get returned to the connection pool.
[ October 21, 2004: Message edited by: Tim Holloway ]

Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: package for connection pooling??
It's not a secret anymore!