Hi Keith, > 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.
Hmm, Base itself does not have a mechanism to re-connect when a connection is lost for whatever reason, so on Base side, I cannot offer you a solution here. What you could try is to prevent the "inactivity". That is, if you produce some minor activity every, say, 9:30 minutes, you could work around the timeout. Clumsy, I know, but the only thing I can think of. In every case, this would involve a macro, which needs the proper activation trigger - which depends on your work flow. Probably some on-load macro for the affected database documents could do. (Or a global on-load macro which checks for loaded DB documents matching your requirements, and then starting a timer for those.) Other than that - I do not know whether the JDBC driver can be thought to automatically re-connect in case of a connection loss, perhaps with some special connection parameter? Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
