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]
