Keith Clark wrote:
On Sat, 2009-07-25 at 17:09 -0400, Drew Jensen wrote:
Keith Clark wrote:
On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:
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?
Yes, I always use the IP and not the DNS name.
Ok - well let me come at this a different way.
Why is this a problem? What is it you want to happen or not happen, i.e
I should not have a new logon screen open just because the connection
was lost.
If I am using Base, and I leave to do something else for 10 minutes and
come back to work some more, Base errors. I have to close down Base and
start it back up again in order to use it.
That is a very short time and a pain to stop and start again.
I use MySQL Query Browser and no matter how long I leave it, for days
even, I can just type a query and execute it. No reconnection required
besides just the original one when I started the program.
Keith
Ok - just making sure I was on the same page with you.
Actually Query Browser times out also - unless you are using a localhost
database server, but I doub't that or we wouldn't be having this
discussion. (hmm, maybe I'm wrong on that - but it doesn't really matter)
I think then the best way to help you is to look at how to handle the
lost connection so that you don't have to shut it all down and start it
all up again - heck, it would be nice if you didn't even know it happened.
But that is not for tonight - sorry. For one thing it would be nice to
address this in a moe generalized way with a set of basic functions ( or
java perhaps) and then perhaps donate this to Roberto should he like to
add said functions to the Base Tools library he is distributing at the
extension site. In other words give it a little thought.
But more importantly - I promised my 16 year old Nephew to take him and
a couple of his friends to the Demolition Derby tonight at the county
fair...just us guys...and need to head the door here pretty quickly.
But I'll get into it with you tomorrow if you like....maybe we can find
others on the list with some ideas also.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
