Fwd: Re: [Coursework-help] JDBC Pool timing out

[Ian B. <ie...@tf...>]

oops forgot to include the list

----- Forwarded message from Ian Boston <ie...@tf...> -----
    Date: Wed, 14 Jan 2004 20:52:29 +0000
    From: Ian Boston <ie...@tf...>
Reply-To: Ian Boston <ie...@tf...>
 Subject: Re: [Coursework-help] JDBC Pool timing out
      To: Sam Ottenhoff <ott...@lo...>

This looks like objects are not being released or returned to the pool. There
are a number of bugs in some of the Servlet implementations in Tomcat where
events on request object reslease and session object release are not propogates
under certain circumstances.

If the pool relies on one of these events to auto release it is likely that it
will "leak" to consume all objects, resulting in a "Timeout waiting for idle
object" which would give a null connection.


Have you tried monitoring the available connections in the pool ?

If they go upwards than perhapse we are not releasing or the auto release
mechanism is not working ( perhapse due to a unhandled exception pathway with
no explicit release )

Ian

Quoting Sam Ottenhoff <ott...@lo...>:

> Has anyone run into problems with their JDBC pool dying?  Our JDBC pool 
> has died a couple of times, and I am not able to track down the cause 
> through logs (nothing abnormal leading up to the pool death).  Any ideas 
> on directions to prevent this from happening?  Adding some code to 
> refresh the pool if it comes back null?  Making sure the pool is closed 
> after use? 
> 
> Thanks,
> Sam
> 
> 13 Jan 2004 12:46:57,828 -- WARN  [Thread-33] (BaseServlet.java) - 
> SQLExceptionjava.sql.SQLException: java.util.NoSuchElementException: 
> Timeout waiting for idle object
> 13 Jan 2004 12:46:57,829 -- WARN  [Thread-33] (CourseMaterials.java) - 
> DB Error: connection was null
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Coursework-help mailing list
> Cou...@li...
> https://lists.sourceforge.net/lists/listinfo/coursework-help
> 


.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

----- End forwarded message -----


.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.