Re: Problem with MySQL connection while inserting data
I solved my problem. (in case that someone could be interested in...)
In my Windows service, I have a Timer that triggers every 3s to manage threads. In this timer, I use "mysql_ping" to test the MySQL connection.
When the ping function runs while the MySQL Server is busy by a query, the connection fails...
So now, I check that no process is working to make a "mysql_ping", and everything is OK...
No problem!!
Thus, remember to never do a "mysql_ping" in the same time of a "mysql_real_query"...
Stef.
Subject
Written By
Posted
November 25, 2009 03:08AM
Re: Problem with MySQL connection while inserting data
December 01, 2009 03:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.