Tomcat and Database Sessions
Midhun Agnihotram
Greenhorn
Posts: 11
posted 6 years ago
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
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
Greenhorn
Posts: 8
posted 6 years ago
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.
take a look at this link
tomcat clustering - how to
I think you cannot do what you want.
--
thiago moraes
