Forgot to include the following: p:idleConnectionTestPeriod="600" p:preferredTestQuery="select 1 from dual"
I don't believe that we are validating the checkout. ___________________ Juan Quintanilla UTS - Enterprise Group 305-348-6573 [email protected] ________________________________________ From: Juan Quintanilla Sent: Monday, October 14, 2013 4:14 PM To: [email protected] Subject: RE: [cas-user] Question regarding CAS and db connections Hi, Where would I see this validate on checkout was enabled? This tends to happen only when we have a high load which is understandable. For example for the c3p0 settings we used to have: p:initialPoolSize="25" p:minPoolSize="25" p:maxPoolSize="50" p:maxIdleTimeExcessConnections="7200" p:checkoutTimeout="14000" p:acquireIncrement="5" p:acquireRetryAttempts="5" p:acquireRetryDelay="10" p:idleConnectionTestPeriod="300" So when we would have a large amount of concurrent users log in at once (over 25) they would be able to authenticate our ldap but when it would try to connect to the oracle database they would be waiting for a connection to the DB and eventually reach the checkouttimeout and see CAS Unavailable and in the logs we see: ERROR [org.hibernate.util.JDBCExceptionReporter] - <An attempt by a client to checkout a Connection has timed out.> Once the extra connections were built to the DB they would be able to login. It was not so much the checkout it was the time taken to create the new connections to the DB. So we have been adjusting the amount of open connections based on the amount of concurrent users we have had. So my question, has anyone else experienced something similar when using oracle and the c3p0 connection pooling? ___________________ Juan Quintanilla UTS - Enterprise Group 305-348-6573 [email protected] ________________________________________ From: Marvin S. Addison <[email protected]> Sent: Monday, October 14, 2013 3:35 PM To: [email protected] Subject: Re: [cas-user] Question regarding CAS and db connections > It seems that the time it takes to create the new connections and for > the old connection to free up is taking longer than the set time of > 20 seconds for the checkout time limit. That sounds unusual. Do you have "validate on checkout" or similar enabled? What's your validation query? Validation is the only reason I could think of where checkout would take so long. M -- 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 -- 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
