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.