dcUniversal MysqlProvider UniTransaction does not rollback changes
Posted: Fri 08 Aug 2014 15:52
I having an issue using UniTransaction with MysqlProvider, "only using loadbalancing feature in connectionstring"
Issue happens only if connectionstring has load balancing feature for example:
Datasource=(127.0.0.1:3306,192.168.10:3306)
Using dcUniversal 3.50.668
Thanks in advance
.......................
try
...
var res = uniCommand.ExecuteNonQuery();// This instruction make partialy changes in database even if error and using unitransaction
uniCommand.Transaction.Commit();
...
catch (Exception ex)
{
uniTransaction.Rollback(); // This instruction does not undo changes because changes were executed partialy (commited until DML Db command was thrown)
}
.......................
Issue happens only if connectionstring has load balancing feature for example:
Datasource=(127.0.0.1:3306,192.168.10:3306)
Using dcUniversal 3.50.668
Thanks in advance
.......................
try
...
var res = uniCommand.ExecuteNonQuery();// This instruction make partialy changes in database even if error and using unitransaction
uniCommand.Transaction.Commit();
...
catch (Exception ex)
{
uniTransaction.Rollback(); // This instruction does not undo changes because changes were executed partialy (commited until DML Db command was thrown)
}
.......................