Re: Reconnecting to mysql connector

[Noam Parness]

I just started playing with this library, on an Arduno Mega 2560 (clone).
It is receiving data over the serial port (at first using SoftwareSerial, but now using the Serial1 port), and then sending that to a MySQL database on the local network. I have it connected using an ENC28J60 ethernet adapter, and using the UIPEthernet library (which allows use of the same commands from the Ethernet library with the ENC28J60).

The Mega receives a stream of data approximately ever 10 seconds, and then is supposed to turn around and do a MySQL INSERT query to put the data into the database.
It works fine for a little while, but it usually breaks within 30 minutes or so (sometimes much faster). It gets to the point of sending the query, but it hangs at that point. I have to press the reset button on the Mega to get it going again.

I installed WireShark on the PC, but I didn't see anything unusual right before it hung.

Is there a way I can implement a "timeout," on the MySQL statemt, so it will jsut continue on if something doesn't work properly?

Thanks.