Devart Forums

Hi, i'm have problem when LocalFailOver is active and the connection is Lost.
MyDAC don't reconnect and Retry.. the Lost Connection exception is Raised.

Please, add this feature for LocalFailOver Restart the transaction and reexecute the sql statment.

to reproduce the problem: http://www.drdsistemas.com.br/util/mydac/

LocalFailOver under transaction doesn't work because MySQL doesn't support committing/rolling back transaction after connection was lost. If after starting transaction connection was lost, all changes will be rolled back by MySQL server.

Dimon wrote:LocalFailOver under transaction doesn't work because MySQL doesn't support committing/rolling back transaction after connection was lost. If after starting transaction connection was lost, all changes will be rolled back by MySQL server.

you can, Reconnect, Start the transaction and reexecute SQL ?

We don't plan to support such functionality, because from starting transaction many queries with large amount data and parameters can be executed. Also there are many questions with preparation/unpreparation queries.

Dimon wrote:We don't plan to support such functionality, because from starting transaction many queries with large amount data and parameters can be executed. Also there are many questions with preparation/unpreparation queries.

ok, thank's Dimon

eduardosic wrote:

Dimon wrote:We don't plan to support such functionality, because from starting transaction many queries with large amount data and parameters can be executed. Also there are many questions with preparation/unpreparation queries.

ok, thank's Dimon

this a great feature for MyDAC 6.00.

Thank you for your advice. We will investigate the possibility of adding this functionality in the future.