Hi, Please find detailed problem statement below 1) Our Application is developed in Java and its an web based application so we use TOMCAT as web server. We deploy the Application on HP-UX mach ine. And we are using connection pooling to connect with the database.
2) During the Deployment we need to stop and start the TOMCAT server lots of times. Afte r successful deployment when we monitor our database we found that hundreds of J DBC sessions are connected with oracle with different log-on time. 3) Now if we kill the session its status shows "KILLED" and its SPID not shown in the V$PRO CESS table we need to kill it either using "IMMEDIATE" or at OS level using "KIL L -9 SPID" 4) Now this is our problem that sessions were not released automatically after shutdown the TOMCAT web sever. Each time we need to kill all session manually. Note: In Windows environment sessions are released successfully after shutdown the TOMCAT webserver. -----Original Message----- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Thursday, July 02, 2009 2:08 AM To: Tomcat Users List Subject: Re: tomcat session is not releasing -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jayesh, On 7/1/2009 4:27 AM, jayes...@birlasoft.com wrote: > In our HP UX server the tomcat session is not releasing from database > even after closing the session. > > Please suggest us how can we resolve the issue I would suggest you post details about your setup: Tomcat does not use a database for session management by default. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkpLyT4ACgkQ9CaO5/Lv0PBirACfRmjTUecbHeqShD4nAJXiTPQB mbsAn2t0D8n2y0G4og6sstmFoyeTpIv8 =+ou2 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org ****************************************************************************************************************************** "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." ****************************************************************************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
