Hello Marco, not sure if that helps but I have found the MySql java list quite helpfull when talking about things like this - especially when it comes to the driver, as Mark Matthews (author of the driver) post frequently to that list. URL: http://lists.mysql.com/java.
Ignore my if you knew that allready ;) Cheers, Jan > -----Original Message----- > From: Marco Mistroni [mailto:[EMAIL PROTECTED] > Sent: Friday, July 30, 2004 12:24 PM > To: 'Struts Users Mailing List' > Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem > > > 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]
