re:[cas-user] CAS has to be restarted after losing database connection

2014-03-04 Thread Peter Johansen
Thank you Marvin and Curtis. Both responses were helpful. Based on reading the link on the c3p0 datasource I added the following to my datasource: p:testConnectionOnCheckin="true" p:idleConnectionTestPeriod="60" -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-ar

Re: [cas-user] CAS has to be restarted after losing database connection

2014-03-04 Thread Marvin Addison
> The scenario is this - the connection to the database goes down, CAS tries to > connect and fails. Connection to database comes back up. CAS continues to > fail until it is restarted. Assuming a connection pool, which is a best practice, there are two solutions: connection validation on idle

Re: [cas-user] CAS has to be restarted after losing database connection

2014-03-03 Thread Curtis Ruck
You should set the validationQuery on the datasource. http://commons.apache.org/proper/commons-dbcp/api-1.3/org/apache/commons/dbcp/BasicDataSource.html#validationQuery -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or ac

[cas-user] CAS has to be restarted after losing database connection

2014-03-03 Thread Peter Johansen
I recently inherited maintenance/support of CAS 3.4.12 for my organization. I have no experience with CAS or even Spring really. I've been reading the docs to try to get up to speed and haven't come across a solution to this particular problem. The scenario is this - the connection to the dat