« Return to Thread: tomcat session is not releasing

Re: tomcat session is not releasing

by Pid-2 :: Rate this Message:

Reply to Author | View in Thread

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@...

 « Return to Thread: tomcat session is not releasing