Thanks Felix, This does look like what I need. On Sun, Oct 7, 2012 at 9:36 AM, Felix Schumacher < felix.schumac...@internetallee.de> wrote:
> > > 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 > >