Hi, This is a known problem with accessing remote mysql database servers with the native driver extension, although I don't remember if a bug/feature issue was made for it. As far as I understand it, the driver extension is a subset of the mysql C client connector so doesn't implement all of the methods/interfaces, and the auto-reconnect (or rather the awareness that the connection has dropped and should be remade) is one of those things. As to when or if it will be fixed in the future, I'd say that is rather much in the air.
You also might want to look at your mysql server settings, because there is a parameter that defines the time out of connections to the server in the face of apparent inactivity. If you can increase that time out to the maximum, you might have more luck with the driver. Here's the link from the MySQL reference manual that indicates what it does : http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout Unfortunately, if your mysql server is located on a mutualised server, then you may be out of luck because you probably won't be allowed to change this configuration option. Many such systems are configured for a timeout of 30 seconds !! Obviously, that's pretty short :-/ Personally, I haven't ever been able to use OOo decently to connect to any of my hosted mysql instances, simply because the connection times out due to network latency issues (bandwidth, DNS lookups, routing, etc), but one can't really blame that on OOo :-)) Alex Alex Thurgood ----- "Marcin Jablonski" <[email protected]> a écrit : > I lose connection after 2-3 minutes (OO Base + MySQL native driver). > How to keep connection with MySQL alive? I hope that someone had the > same problem and solve them. Please, share it. Thx --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
