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)
}
.......................
dcUniversal MysqlProvider UniTransaction does not rollback changes
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dcUniversal MysqlProvider UniTransaction does not rollback changes
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dcUniversal MysqlProvider UniTransaction does not rollback changes
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dcUniversal MysqlProvider UniTransaction does not rollback changes
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
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