Java EE (Java Enterprise Edition) General Discussion

Hi :

We are facing this peculiar problem of Invalid Sessions in database. There are Inactive sessions for days together in Database.

We are using a common utility for all select Queries; along with that we are using datasource to get connection object. We have even checked that common component for connection closing. The code seems to be fine as such first we have closed resultset then statment and then connection object.

But I found on few sites that we should set all the objects to null. That will server the purpose.

But then we have implemented Connection pooling along with that we are also purging timeout connections along with that we are using Reap time settings etc.

Still there are inactive session objects being held for days together.

Is there anything more on Application part to be done or is it a bug at database front.

Avadhoot Sawant