Connection issue with Tomcat JDBCRealm

[Douglas Jose]

Hi,

I'm developing an application with Tomcat 5.5.23 and MySQL 5.0.27. After some time of inactivity (usually one day) I'm having the following exception when trying to access a protected area of my app (which requires authentication):

SEVERE: Exception performing authentication
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
at com.mysql.jdbc.Connection.getMutex(Connection.java:3714)
at com.mysql.jdbc.Connection.commit(Connection.java:2268)
at org.apache.catalina.realm.JDBCRealm.getPassword(JDBCRealm.java:570)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:401)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:349)
at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)

Somebody can help me fix this issue?

Kindly,

Douglas