tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aladin Dajani <aladin.daj...@gmail.com>
Subject JDBCRealm conection timeout failure on getPassword
Date Sun, 07 Oct 2012 12:57:20 GMT
Hello List,

My application is configured for JDBCRealm authentication uses a MySQL
database.
For my own use inside the application, I have setup a connection pool to
access the database,  However, the configuration of JDBCRealm in server.xml
uses astand-alone connection.  Since MySQL times-out connections after 8
hours, I get the following error in tomcat logs as I try to log-in after
the connection times out:

Oct 7, 2012 8:36:51 AM org.apache.catalina.realm.JDBCRealm getPassword
SEVERE: Exception performing authentication
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No
operations allowed after connection closed.Connection was implicitly closed
by the driver.

Users do not notice this error (I presume tomcat's JDBCRealm will create a
new connection), but it is disconcerting to have all these exceptions in
tomcat logs, especially that when the server goes into production mode, I
fear this will have adverse effects.

Is it possible to have JDBDRealm use the same connection pool which my
application uses (which is setup in tomcat's context.xml so it should
be accessible to all applications in tomcat).

Thanks.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message