Oracle data connector

[Gregory Haverkamp]

On Thu, Aug 25, 2011 at 8:48 AM, Stefano Zanmarchi <zanmarchi at gmail.com> wrote:
> Is there another known solution to the "idle period" problem using an
> Application Managed connection?


I've gotten around it by messing with the various times.  I haven't
had problems since.

I keep a pretty short idle time and test period, and that seems to
have fixed it.  (I assumed it gets under whatever the database itself
was imposing.)  That may or may not work in your environment.

The following's been working for me for 9 months or so:
poolAcquireRetryAttempts="3"
                                      poolBreakAfterAcquireFailure="false"
                                      poolAcquireRetryDelay="1000"
                                      poolMaxIdleTime="45"
                                      poolIdleTestPeriod="15"

Greg