tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aladin Dajani <aladin.daj...@gmail.com>
Subject Re: JDBCRealm conection timeout failure on getPassword
Date Sun, 07 Oct 2012 13:41:26 GMT
Thanks Felix, This does look like what I need.

On Sun, Oct 7, 2012 at 9:36 AM, Felix Schumacher <
felix.schumacher@internetallee.de> wrote:

>
>
> Aladin Dajani <aladin.dajani@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

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