Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of aladin.dajani@gmail.com
 designates 74.125.82.173 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <d4507436-04e9-4171-a12b-fe61fba85bf1@email.android.com>
References: 
 <CAHt=FYn1yXp7KM8yJuZKjdZE_eA5QrGouR1x_BvQ_6Jxmb=AJg@mail.gmail.com>
	<d4507436-04e9-4171-a12b-fe61fba85bf1@email.android.com>
Date: Sun, 7 Oct 2012 09:41:26 -0400
Message-ID: 
 <CAHt=FYnXHroAn5MHr8jTj7hEbPTcAGQ2P50O9BXBSPfDJDXpXA@mail.gmail.com>
Subject: Re: JDBCRealm conection timeout failure on getPassword
From: Aladin Dajani <aladin.dajani@gmail.com>
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: multipart/alternative; boundary=f46d04428f34f8124304cb7842d3

--f46d04428f34f8124304cb7842d3
Content-Type: text/plain; charset=ISO-8859-1

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
>
>

--f46d04428f34f8124304cb7842d3--