Keith Clark wrote:
On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
All that parameter does is tell the driver to attempt a reconnect if
the connection drops. Depending on how you access your remmote mysql
server, you can still be disconnected. I have the same problem with my
ssh redirected mysql connection. I first thought that the ssh server
disconnected me after a certain timeout, but apparently it is, in my
case at least, a network reliability problem, i.e. the actual internet
connection is not stable enough and the server detects that my
connection has dropped and thus severs any further attempt until I
manually reinitialise the connection. PITA, but unfortunately have no
other solution. I also get at the OOo end a JDBC error message "the
server has had no activity for the last X ms" where X is variable.
I don't think my problem is connectivity. Same error, but I've tried it
on two different installations with two completely different internet
connections. One is cable the other phone company.
One thing for sure after doing a little research for you - you guys are
not alone with this problem.
Anyway - and this is just something that seemed to come up a fair bit in
my readings:
Have you tried using the actual IP address to the server in your
connection settings and not a DNS name?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
