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]