On Tue, 2009-08-11 at 22:25 +0200, Frank Schönheit - Sun Microsystems
Germany wrote:
> Hi Keith,
> 
> > In your absence an issue of the jdbc connector getting disconnected from
> > a remote MySQL database and not being able to reconnect without
> > restarting OO.o Base.  Not sure if you have followed the conversation at
> > all.
> 
> I fear I didn't - this was a thread which looked like I couldn't cope up
> with it with reasonable effort :-\
> 
> > If not, I could re-raise it again.
> 
> Please do so, though from the little I read in this thread, I fear I
> might have no clue ...
> 
> Ciao
> Frank
> 

Frank,

I am using Base to connect to a remote MySQL database with the JDBC
connector.  They have an inactivity set for a ridiculously low time of
10 minutes.  When that time elapses, it disconnects and Base generates
an enormous error window (it exceeds my screen) stating that it lost
contact so many ms ago.

The only solution is to close Base and restart.

Now, I use MySQL Administrator and MySQL Query Browser and they never
seem to tell me when a connection is lost.  They must just connect again
in the background without generating an error at all.

I was wondering if there was some setting/solution to have Base do the
same.  My web host will not increase the inactivity timeout for me.
They claim security issues.

I've searched all I can over that past few weeks with no solution, and
this problem is driving us crazy!  Any help would be appreciated.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to