Hi The problem is that when tomcat starts this process exists but after shutting down the tomcat still this process is existing at operating system level and in this way after many times tomcat startup and shutdown many processes as same below showing and due to that JDBC sessions from Oracle database level is not closing. Manually when we use to kill those sessions, immediately JDBC sessions closed. tomcat 24453 1 2 16:11 pts/4 00:00:23 /opt/java1.5/jdk1.5.0_10/bin/java -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/opt/jakarta-tomcat-5.5.9/common/endorsed -classpath :/opt/jakarta-tomcat-5.5.9/bin/bootstrap.jar:/opt/jakarta-tomcat-5.5.9/b in/commons-logging-api.jar -Dcatalina.base=/opt/jakarta-tomcat-5.5.9 -Dcatalina.home=/opt/jakarta-tomcat-5.5.9 -Djava.io.tmpdir=/opt/jakarta-tomcat-5.5.9/temp org.apache.catalina.startup.Bootstrap start tomcat 24454 1 0 16:11 pts/4 00:00:00 /usr/local/sbin/cronolog /opt/jakarta-tomcat-5.5.9/logs/catalina.out.%Y-%m-%d Operating System --- RHEL 4 Default web server with OS --- jakarta-tomcat-5.5.9 Default Java --- JAVA 1.5 Database --- Oracle 10.2.0.4.0
Regards Santosh ****************************************************************************************************************************** "This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail(administra...@birlasoft.com) immediately and permanently delete this message and any attachments. Thank you." ******************************************************************************************************************************
