Devart Forums

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)
}
.......................

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

We have fixed the bug with autocommitting UniTransaction when using the load balancing feature with MySQL. We will post here when the corresponding build of dotConnect Universal is available for download.

New build of dotConnect Universal 3.50.722 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=30169