Re: 11G jdbc connection pools timeing out

From: Sylvester, Peter A. <peters_at_mitre.org>
Date: Mon, 19 May 2008 18:38:59 -0400
Message-ID: <2BA3384D0B8F9A41A906D1FFC25EB35D027783C2@IMCSRV3.MITRE.ORG>


What is meant by connection pools "stop working"? Some connection pools will automatically close down connections during idle periods.  

If you are getting hard errors, many pools give you the ability to specify SQL which is run to test out the connection (i.e. "select 1 from dual") before letting the application use it. This can usually get around issues associated DB restarts etc.  

--Peter

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 19 2008 - 17:38:59 CDT

Original text of this message