+1. Had same behavior with autoReconnect=true
> -----Original Message----- > From: Mark Lowe [mailto:[EMAIL PROTECTED] > Sent: Friday, July 30, 2004 6:36 AM > To: Struts Users Mailing List > Subject: Re: OT/ Tomcat, Hibernate and MYSQL problem > > > I went down the same road using autoReconnect="true" to no avail. Had > the same thing with tc4 and 5.. And c3po and dcbp.. Turned out to be > the driver. > > I'd try the version 2 driver and then try the version 3 driver with > c3po, and test joe's and my competing theories.. > > On 30 Jul 2004, at 12:24, Marco Mistroni wrote: > > > Hello, > > > >> Marco, please tell us what winds up happening with your > app. I'm now > >> very curious. > > > > > > Well, I m using, as I said, mysql connector 3.0.11, with mysql 4.1 > > alpha & hibernate together. > > My app is running on tomcat 5.0 > > > > I m using hibernate 2.1. I haven't configured any > connection pools on > > Tomcat, but I m using hibernate built it connection pool. I > m leaving > > my app running all the time, couple of days ago I noticed that > > When I tried to connect to it from work, I got exception. > > After, I went home, checked what was wrong (something I found out > > already > > Couple of months ago, without using hibernate, but when I was still > > using > > Mysql).. > > I don't remember exactly where, but I found out htat > usually after 9 > > hrs > > The connection to mysql drops (dunno if only with tomcat, or with > > something else). > > So, I tried this > > <property name="connection.autoReconnect">true</property> > > <property name="connection.autoReconnectForPools">true</property> > > <property > > name="connection.is-connection-validation-required">true</property> > > > > still didn't work > > > > so I tried to add autoReconnect=true to JDBC URL and run following > > tests > > - connecting after 1 hour being idle - everything ok > > - connecting after 3 hours being idle - everything ok > > - connecting after 7 hrs being idle - everything ok. > > > > I thought I have solved the problem, but between today and > yesterday, > > I left App running after 13 hours being idle.... and > problem appeared > > again. > > > > And that's when I posted the problem...... > > > > Thanx 4 any feedback > > > > Regards > > marco > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
