Hi List, I still figthing with this problem but I can't found one solution.
If the application loses internet connectivity, due by that MySQL disconnects connects clients after a period of inactivity or you hibernate the computer, the connection is lost, but, revOpenDatabases() still returns a value. But there is no connection, so running a query or any DB command hangs the software forcing sometimes a force quit or wait until 10 minutes to get the error. As I read in the forum one solution is disconnect each time before to execute any query. Two questions: a) Anybody have found any solution for this, I tryed some things founded in the forum but doesn't work, so really the connection with mySQL is OK, the ports are accessible... Also I post a bug http://quality.runrev.com/qacenter/show_bug.cgi?id=8723 b) Send in time some function can work but how control after hibernate the computer and the user perform some query? I don't know if I explain myself. The problem that I detect is after the user recover the computer after hibernate it. The application is loaded like other application, and perform some query. In this moment the computer have internet connection, and if I check for the mySQL ports or ping, the result is ok. So I think about some timer that fire one condition to disconnect before to perform the next query, after this first disconnect the next ones work fine. Any ideas? Salut, Josep -- View this message in context: http://n4.nabble.com/MySQL-has-gone-away-again-tp1898138p1898138.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
