I am using a standalone hibernate connection for oracle connection(without spring) in my application for a process. i am opening new hibernate session for every cycle of the process and also close at the end of every cycle. But the session that were opened and closed for the process still have entry in the v$session table in Inactive status however the only session that is currently used is present in the active status. because these used sessions gets stagnated in the Inactive state even after closing them, after a limit i am not able to open any new session. In other words it also leads to total loss of DB connection. Is there any way to get rid of these Inactive sessions?

can anyone help me in clearing this problem?

Can you post the log please?
Try to call sessionFactory.getCurrentSession() instead of sessionFactory.openSession()

I have one application which is using Struts Framework and Hibernate. In my application, Whenever code fetches data from database using hibernate , it makes some inactive sessions in database. in code we have used getCurrentSession method. we have closed the session object also. but still we are getting inactive sessions in database for each of the methods.

Another thing is we are using hibernate-cfg.xml. Is there anyway where we can define to kill the session automatically after some particular time.


please reply to this post asap. I want to fix this asap.

Hi,

for that workaround, manually closing timed out connections, depending on the database engine your using, you could probably specify a connection timeout in jdbc url. I've shamelessly recurred to this trick before, as a last chance to overcome my lack of knowledge :)

Hi All,

I got the solution for this issue. We can use JNDI entry in hibernate-cfg.xml file We have connection attribute in the xml file there we can define which JNDI entry is required for the connection. So each time when u create sessionFactory object it will take the existing one untill u close it.

Let me know if further clarifcation required

Hi,
I am facing the same problem. Could you plz clarify the solution. Which JNDI entry u mean?