Hello,
The scenario is this:
-my program uses MyDac to connect MySql server
-sometimes (1-3 times a day) the connection is lost
-the program reconnects automatically (at onConnectionLost)
-at this moment the last executed command is repeated on the server.
Because almost all commands are Insert-s this provides a great problem e.g. an invoice row is duplicated.
How can I prevent this?
Thank you.
Reconnecting the MySql server reposts the last command
Re: Reconnecting the MySql server reposts the last command
To solve the issue, you can set the RetryMode variable to rmReconnect, but not to rmReconnectExecute.
Re: Reconnecting the MySql server reposts the last command
Thank you very much!
Re: Reconnecting the MySql server reposts the last command
Thank you for your interest to our product.
Thank you for the feedback and interest to our product.
Thank you for the feedback and interest to our product.