This is just a sidey way to do it. Before stopping you can execute some code
which closes/releases all the open connections. You can add it to the tomcat
script.
-----Original Message-----
From: Brahmanand Gannur [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 3:49 PM
To: [EMAIL PROTECTED]
Subject: tomcat restart and oracle session
Hi
we are facing a typical problem
we are working on solaris 2.7 tomcat3.2.1 and apache1.3.5 platform with
oracle8i as backend
whenever i do some database driven work using my frontend(JSP) the session
are created(from connection pool)
whenever i restart my tomcat all sessions assosiated with the tomcat should
be released(idealy) but the old sessions still remain and new sessions get
added to it
can u help me how to kill sessions created on oracle server because of
tomcat (this is important because we have limited acess of 10 sessions)
help out
Thanks in advance
Brahma
