You should consider implementing the finalize() method in your session bean to 
close the connection nicely. In theory a well behaved JDBC driver should clean 
up after itself. I don't like relying on theory. If you open the connection in 
your session bean, close it there.

Earnie!

-----Original Message-----
From: Serlet Jean-Claude [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 9:09 AM
To: 'users@tomcat.apache.org'
Subject: TR: Time out on sessions with AJP13


> Hello
> Third and last   send of this message : i didn't  get any answer until to
> day  
> 
> My environment : OS= Windows 2000
>               Web Server = Apache 2.0
>               Tomcat-Apache = 1.4.31 with AJP 13 connector
>               Application uses JSP, Servlet and Driver JDBC Thin of Oracle
>               RDBMS = Oracle 7.3.62 under z/OS (mainframe IBM)
> The application does'nt use connexion pooling : one physical connexion is
> used for each user 
> The connexion is explicitly closed only when the user click on the button
> "Quit" of the application
>  What's happen  when a session is timed out ( without activity during the
> time set in web.xml)
>  for the processor(limited by maxProcessor of ajp13) in which the last
> request was executed ? does this processor be released ?
> what's happen for the connexion to the database ?
> i didn't find documentation for this situation on the web : only about
> "howto" configure AJP13 connector ( that is done )
> Last day i have to reboot the tomcat instance because the maxProcessor was
> reached ( saw it in the log of Tomcat )
> I suppose that many users don't quit the application properly
> I see many more sessions open in the database than users connected ( under
> z/os  the connection  not cleanly closed stay ther 
> until the shutdown of database)
> Any idea about the code built by the developpers : i asked them to close
> properly every object created after the end of its use specially "prepare
> statement, result set..."?
> Regards
> 
> [EMAIL PROTECTED]
> 
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to