dcUniversal MysqlProvider UniTransaction does not rollback changes

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

dcUniversal MysqlProvider UniTransaction does not rollback changes

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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Post by 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: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Post by 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: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dcUniversal MysqlProvider UniTransaction does not rollback changes

Post by 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/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

Post Reply