File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes Connection from DataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Connection from DataSource" Watch "Connection from DataSource" New topic

Connection from DataSource

Madan Kulkarni

Joined: Sep 23, 2002
Posts: 5
I have a question regarding the JDBC Connection object from DataSource.

I have created the connection pooling in WAS 4.06 Application Server thr' administrative consol.

In my ConnectionWraper class, I am searching the data source object thr' JNDI search and then using datasource.getConnection() method to get the JDBC Connection object to perform Database SQLs.

When I complete the SQL execution, I am closing the resultset, statement and connection objects in respective methods.

Now, my question is, when I am closing the connection object with connection.close() method, will this connection object return to the connection pool or not?

Java Programmer
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33124

Yes, the connection is then returned to the pool.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Connection from DataSource
It's not a secret anymore!