Page 1 of 1

Reconnecting the MySql server reposts the last command

Posted: Mon 24 Apr 2017 10:03
by starhu
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.

Re: Reconnecting the MySql server reposts the last command

Posted: Mon 24 Apr 2017 13:47
by ViktorV
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

Posted: Mon 24 Apr 2017 17:38
by starhu
Thank you very much!

Re: Reconnecting the MySql server reposts the last command

Posted: Wed 26 Apr 2017 11:33
by ViktorV
Thank you for your interest to our product.
Thank you for the feedback and interest to our product.