File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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: 17423

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 ]

An IDE is no substitute for an Intelligent Developer.
I agree. Here's the link:
subject: package for connection pooling??
jQuery in Action, 3rd edition