Reconnecting the MySql server reposts the last command
Posted: Mon 24 Apr 2017 10:03
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.
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.