Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat and Database Sessions

 
Midhun Agnihotram
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic