Connection from DataSource

[Madan Kulkarni]

Hi,
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?

[Jeanne Boyarsky]

Madan,
Yes, the connection is then returned to the pool.