Transaction Scope v5.40.39

Transaction Scope v5.40.39

Postby Wesley » Fri 07 Aug 2009 04:03

Devart.Data.MySql.MySqlException : XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state


Steps to reproduce
1) Create a table with 2 columns in mysql (id, name). Id is an autoincrement
2) Created new solution in VS2008,
3) Added a dataset to the solution
4) Added a tableadapter for the single table in mysql
5) Added th following code

Code: Select all
           
using (TransactionScope _scope = new TransactionScope())
            {
               
            DataSet2TableAdapters.alphaTableAdapter adapter = new MySQLTransactionScope.DataSet2TableAdapters.alphaTableAdapter();

            adapter.InsertQuery("inside scope"+DateTime.Now.ToString());
     
            }



When this code runs the following error occurs Devart.Data.MySql.MySqlException : XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state
Wesley
 
Posts: 4
Joined: Fri 07 Aug 2009 03:58

Postby AndreyR » Fri 07 Aug 2009 12:39

Thank you for the report, I have reproduced the problem.
I will let you about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Wed 19 Aug 2009 14:33

We have fixed the problem. The fix will be included in the next build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL