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>
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