Tomcat and Database Sessions

[Midhun Agnihotram]

Hi All,

Our application set up is as follows : Tomcat 5.5 + Java 1.5 + Spring 2 + Hibernate 3.3 + Atomikos + Oracle 10G. Our application session timeout is set to 30 minutes in web.xml. With some heavy processing, we find that there are a lot of INACTIVE sessions in the Database. These might be due to the user closing the window or the web session timing out, etc - it is not clear.

How do I set to close my database sessions when the web sessions close ? Is there a way to clear the database sessions if the web sessions are active ?

Thanks,
Midhun

[Thiago Alves de Moraes]

Are you using Session replication with a shared database ?

take a look at this link
tomcat clustering - how to

I think you cannot do what you want.