Add ;autoreconnect=true to the db connect string.
> -----Original Message-----
> From: Herchel Wojciech [mailto:[EMAIL PROTECTED]]
> Sent: den 28 februari 2001 17:32
> To: 'Tomcat'
> Subject: Tomcat and mySQL
>
>
> Hi!
>
> I'm using JDBCRealm authorisation.
> How can I force mySQL not to close the connection Tomcat
> opened upon startup
> (to database where users, roles, user_roles tables are stored)?
> i assume mySQL's variable wait_timeout is responsible for
> closing inactive
> connections. the default is 28800 secs, will changing it to
> zero do the
> trick? or else? anyone?
>
> regards,
>
> vVolf
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]