Hi,
We have been experiencing some problems with CAS and our oracle DB. We have 2
CAS 3.4.7 web servers load balanced with oracle for the ticket registry and
ldap as the authentication.
The problem we run into is that at certain times we find the following errors
in the cas log:
ERROR [org.hibernate.util.JDBCExceptionReporter] - <An attempt by a client to
checkout a Connection has timed out.>
We have played around with the the C3P0 values and have been fine for some time
but we have encountered the issue once again.
When I checked the # of successful ldap authentications found in the cas log
the number of successful connections for the time in which the error occured
was much lower then the maximum connections setup in the C3P0. My assumption
is that it only gives a db session after a successful ldap authentication. So I
wondering if the connections used by the C3P0 are not being released in a
timely manner or released at all. For example issue occurred at 5:55pm there
were a total of 491 connections between 5:50 and 5:59.
We have the following for our C3P0 settings:
p:initialPoolSize="350"
p:minPoolSize="350"
p:maxPoolSize="400"
p:maxIdleTimeExcessConnections="7200"
p:checkoutTimeout="20000"
p:acquireIncrement="5"
p:acquireRetryAttempts="5"
p:acquireRetryDelay="10"
p:idleConnectionTestPeriod="300"
p:preferredTestQuery="select 1 from dual"
I have been looking into this issue for some time now, so any help would really
be appreciated. If anyone can relate their experience with CAS and Oracle using
C3P0
___________________
Juan Quintanilla
UTS - Enterprise Group
305-348-6573
[email protected]<mailto:[email protected]>
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
