Lost connection to MySQL server during query

Postby GEswin » Mon 22 Aug 2005 12:58

I have at server set

Code: Select all
wait_timeout         28800
interactive_timeout  28800


These are default values, and never experienced any problems. Using mysql 4.1.03 up to 4.1.13a. Perhaps you changed this and there isn't really the need to do it.
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Postby Ikar » Mon 22 Aug 2005 13:30

> I think components should reconnect automatic, like DBX did.

Automatic reconnection is performed but a query not passed to the server again.

In general for cases with unstable connection (GPRS etc) it would be correct to use СachedUpdates along with transactions.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby solata » Mon 22 Aug 2005 14:32

Anyway the problem is solved with ping and biggest timeout.

I think implementing this in new MyDac release would be great.

Thank you GEswin and Ikar.
solata
 
Posts: 12
Joined: Tue 12 Jul 2005 07:29

Previous

Return to MySQL Data Access Components