Aladin Dajani <aladin.daj...@gmail.com> schrieb:
>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 US 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). Have a look at DatasourceRealm. Regards Felix > >Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org