Member_2_7965240
asked on
MySql transaction with lost database connection
Hello,
I have an application which uses remote MySql database (it connects the database via internet).
The Internet of one of my clients is very unstable.
Because of this I intend to put the Sql statements in a transaction.
The question is: if I start a transaction and in the middle of it there is a "Lost connection" with the database, the previous Sql statements will roll back, right?
Thank you very much.
I have an application which uses remote MySql database (it connects the database via internet).
The Internet of one of my clients is very unstable.
Because of this I intend to put the Sql statements in a transaction.
The question is: if I start a transaction and in the middle of it there is a "Lost connection" with the database, the previous Sql statements will roll back, right?
Thank you very much.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.