DTC issue with WCF Transaction

DTC issue with WCF Transaction

Postby RitenGohil » Tue 09 Aug 2016 09:04

Hi, I am using WCF transaction and within the transaction scope calling the wcf services.

For e.g. In transaction scope, we are calling GetName method of service1 and then GetAddress method of service1. First method call i.e. GetName executes properly but while trying to execute the second method i.e. GetAddress, it is giving exception "The underlying provider failed on Open.Connection is already attached to distributed transaction."

- It is happening when hitting the methods of same service.
- Using devart dotconnect mysql version 8.4.583.0
- .Net Framework 4.0
RitenGohil
 
Posts: 2
Joined: Tue 09 Aug 2016 08:50

Re: DTC issue with WCF Transaction

Postby Shalex » Thu 11 Aug 2016 14:21

We have asked for the additional information by email.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Re: DTC issue with WCF Transaction

Postby RitenGohil » Wed 24 Aug 2016 08:32

Hi, We have already given the test project and other required details for this issue. It is kind of blocker for our project. The same code works fine with SQL Client.

Please guide us how to resolve this issue.
Awaiting for your reply.
RitenGohil
 
Posts: 2
Joined: Tue 09 Aug 2016 08:50

Re: DTC issue with WCF Transaction

Postby Shalex » Thu 25 Aug 2016 13:53

Thank you for your test project. We have reproduced the "Connection is already attached to distributed transaction." issue and are investigating it. We will notify you about the result.

As a workaround, please set "Pooling=false;" in your connection string (verified, it works).
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44

Re: DTC issue with WCF Transaction

Postby Shalex » Thu 22 Sep 2016 15:58

The bug with enlisting connections to a distributed transaction is fixed in the newest (8.6.743) build of dotConnect for MySQL.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL