dcUniversal MysqlProvider UniTransaction does not rollback changes

dcUniversal MysqlProvider UniTransaction does not rollback changes

Postby idem84 » 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)
}
.......................
idem84
 
Posts: 50
Joined: Thu 04 Apr 2013 19:12

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Postby Pinturiccio » Mon 11 Aug 2014 08:58

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Postby Pinturiccio » Wed 13 Aug 2014 10:40

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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Postby Pinturiccio » Thu 14 Aug 2014 15:23

New build of dotConnect Universal 3.50.722 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/universal/download.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
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal