Stupid questions (sorry): - Are you sure that you are using the tomcat connection pool ? - have you dump (by logging or by a simple system.out.println) your connection objets to see if you are reusing the same or a new one ?
Good luck On 10/11/06, DE VINZELLES, Guillaume (ext.) <[EMAIL PROTECTED]> wrote:
We've checked it two weeks ago, but we got to be sure, so we are doing it again today (and tomorrow, I expect). Thanks for the advice. Guillaume de Vinzelles DSI/PFS Neuf Cegetel Altran Technologies [EMAIL PROTECTED] 01 70 18 21 64 -----Message d'origine----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Pascal Alberty Envoyé: mercredi 11 octobre 2006 16:10 À: Tomcat Users List Objet: Re: JDBC Pool exhaustion Check your code to unclosed connections (and statments) first ! On 10/11/06, DE VINZELLES, Guillaume (ext.) <[EMAIL PROTECTED]> wrote: > Hello there, > > We are running a Tomcat 5.5.17 on a Sun Solaris system (SunFire V240) with a Sun JVM 1.5, and we are facing unavoidable JDBC pool exhaustions. We are using an Oracle 9i database. > > Here is the JDBC entry from our server.xml: > > <Resource name="jdbc/Signup" auth="Container" type="javax.sql.DataSource" > driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@address:port:schema" > username="user" password="pass" maxActive="120" maxIdle="10" maxWait="5000" removeAbandoned="true" removeAbandonedTimeout="60" /> > > The Tomcat manager shows around 1000 sessions on the server, which seems to be pertinent. > > We can see with the JMXProxy that the JDBC pool connections are never recycled, e.g. the active connections number is going higher and higher and never stays at the same level, which is strange because the amount of active sessions isn't growing. > > Do you have any idea about what we can do to 'force' the Tomcat server to release the unused JDBC connections? > > Thanks in advance, > > Best Regards, > > Guillaume de Vinzelles > DSI/PFS Neuf Cegetel > Altran Technologies > > [EMAIL PROTECTED] > > 01 70 18 21 64 > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Pascal Alberty http://pascal.albertyorban.be --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Pascal Alberty http://pascal.albertyorban.be --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
