On Tue, 2009-08-11 at 23:11 +0200, Frank Schönheit - Sun Microsystems Germany wrote: > 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 >
Hi Frank, That was my original idea. Just "touch" the database every 5 minutes but I have no idea how to program that. I could not find a timed trigger. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
