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]
