|

»

tomcat session is not releasing

View: New views

6 Messages — Rating Filter: Alert me

	tomcat session is not releasing by jayesh.m :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, 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 Regards, Jayesh M **************************************************************************************************************************** "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(administrator@...) immediately and permanently delete this message and any attachments. Thank you." ****************************************************************************************************************************
	Re: tomcat session is not releasing by Christopher Schultz-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jayesh, On 7/1/2009 4:27 AM, jayesh.m@... 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-unsubscribe@... For additional commands, e-mail: users-help@...
	RE: tomcat session is not releasing by jayesh.m :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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:chris@...] 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, jayesh.m@... 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-unsubscribe@... For additional commands, e-mail: users-help@... **************************************************************************************************************************** "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(administrator@...) immediately and permanently delete this message and any attachments. Thank you." **************************************************************************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: tomcat session is not releasing by Pid-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On 2/7/09 06:50, jayesh.m@... wrote: > Hi, > Please find detailed problem statement below These are details about your problem, not about your setup. What (exact) version of Tomcat are you using? > 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. Pedant Police: "Tomcat", not "TOMCAT", not "TomCat", nor tOmCaT etc. > 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. So you don't mean Tomcat user sessions, do you mean JDBC Connections? Are you properly closing the connection each time you use one? It sounds like you aren't. p > 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:chris@...] > 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, jayesh.m@... 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-unsubscribe@... > For additional commands, e-mail: users-help@... > > **************************************************************************************************************************** > "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(administrator@...) immediately and permanently delete this message and any attachments. Thank you." > **************************************************************************************************************************** > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	RE: tomcat session is not releasing by Caldarale, Charles R :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message > From: jayesh.m@... [mailto:jayesh.m@...] > Subject: RE: tomcat session is not releasing > > 2) During the Deployment we need to stop and start the TOMCAT server > lots of times. Why? You should be able to simply restart the webapp being changed, not the entire container. > 3) Now if we kill the session What are you doing to "kill the session"? For that matter, exactly what do you mean by "session"? If it's the DB connection you're referring to, don't you have a timeout configured for it on the DB end? > 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. How are you shutting down Tomcat? What software is managing the connections? If you're not using Tomcat's DB connection pooling, then your webapp code is responsible for closing the connections. You may also have a badly configured DB, since it doesn't appear to be dropping stale connections. - Chuck P.S. Just reply to the list, not individually to anyone that responds to you. THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: tomcat session is not releasing by Christopher Schultz-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pid, On 7/2/2009 5:44 AM, Pid wrote: > On 2/7/09 06:50, jayesh.m@... wrote: >> 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. > > So you don't mean Tomcat user sessions, do you mean JDBC Connections? > > Are you properly closing the connection each time you use one? It > sounds like you aren't. +1 Depending on the database, statements and cursors might not be released, even after client termination. Try reading http://blog.christopherschultz.net/?p=68 for some hints for coding against a database connection pool (or really any JDBC programming, really). You'd be surprised at how big an impact a missing Statement.close() can have on your RDBMS. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkpMxg0ACgkQ9CaO5/Lv0PAlugCeK7zZgwJ1cYEXlNrM9d+pHzCm 9VIAniVbfh0UL+6sEcxeMtBMCnY9UQez =P1Lf -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...