LocalfailOver don't work under a transaction..

eduardosic · Post by **eduardosic** » Thu 04 Feb 2010 01:11

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/

Dimon · Post by **Dimon** » Thu 04 Feb 2010 08:17

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.

eduardosic · Post by **eduardosic** » Thu 04 Feb 2010 10:45

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 ?

Dimon · Post by **Dimon** » Thu 04 Feb 2010 12:23

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.

eduardosic · Post by **eduardosic** » Thu 04 Feb 2010 14:24

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 · Post by **eduardosic** » Fri 05 Feb 2010 18:51

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.

Dimon · Post by **Dimon** » Mon 08 Feb 2010 07:52

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