MySQL error with JDBC authentication every 8 hours

[Romain BOURGUE]

Hi,

Somehow your connection seems to be closed on the mysql side and the Cas server 
doesn't notice it before using the connection...

You could try to add these to your datasource :
		<property name="testOnBorrow" value="true" />
		<property name="validationQuery" value="select 1" />

It should help... If it doesn't, post the exception, it should be somewhere in 
your logfile...


Romain

Sudirikku Mohanjith a écrit :
> Hi,
> I have configured CAS to use JDBC authentication handler. I'm using
> MySQL for storing the user data. However if I leave CAS idle for more
> than 8 hours, it gives a MySQL related error. I haven't actually seen
> the error, one of the users reported it.
> 
> It sounds like MySQL had closed the connection, and CAS doesn't try to
> reconnect without compaining.
> 
> Any help will be appreciated.
> 
> Cheers,
> Mohanjith
> _______________________________________________
> Yale CAS mailing list
> cas at tp.its.yale.edu
> http://tp.its.yale.edu/mailman/listinfo/cas
>