connection releasing problem in weblogic.

[Vikas Sahu]

Hi,
I am using weblogic server to get the connection from the pool
with the helt of data source the code is given below -

Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup ("jdbc/NMS");
conn = ds.getConnection();

But the problem is i am not able to release the connection.
How I release the connection.
I am continuously taking connection from the data source but not releasing.

Thanx in advance.
Regards -
Vikas Kumar Sahu.

[Mattias Arthursson]

If you close your connection using conn.close() it will be returned to the pool, but the actual connection will not necessarily be released. However, when you get a new connection from the pool this previous connection might be used again, eliminating the overhead of actually creating a new connection.

You can specify the preferred and maximum number of active connections, as well as the timeout for the connections (i.e. the time it takes before they are actually released by the server if unused) in the pool using the administration console.

[Vikalp Singh]

Hi Vikas,

Releasing the connection is not our hand. It depends on the container.
But when you do Connection.close(), then connection is aviable to Container to recollect it and give it to another resource if required.