For any who are using MySQL and JDBCRealm, configuring the connection string
in server.xml and adding the autoReconnect=true param fixed the timeout
problem I was having with MySQL.
>From server.xml:
connectionURL="jdbc:mysql://localhost/dbName?autoReconnect=true"
I'm very glad to have this one solved! Thanks to all who gave suggestions.
--jeff
----- Original Message -----
From: "Jeff Kilbride" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:04 PM
Subject: Re: JDBC Realm problem
> Hi Andrew,
>
> >From the mm.mysql docs:
>
> Name: autoReconnect
> Use: should the driver attempt to re-connect if the connection dies?
> (true/false)
> Default Value: false
>
> I wouldn't have found this without your pointer, so thanks! I'll give it a
> try and see what happens.
>
> I'd love to see your connection pool implementation for JDBCRealm. Would
you
> be willing to send it to me outside the list?
>
> Thanks,
> --jeff
