April 12, 2016 at 2:46 pm
Hello. It seems that the jdbc connector is defaulting to distributed transactions. We have a stored procedure that reads some data from a linked server in another domain.
exec usp_migraterec @srcrcid = 123
I can run it manually from SSMS and it succeeds.
When the java connector through an application does it, it is handled as a distributed transaction. This isn't working for us. Maybe due to firewall.
Is this behavior something that it set in the SQL Server data source? We would like it to run as a non distributed transaction so it can succeed.
Thank you
June 10, 2016 at 10:41 am
We found that opening the DTC transaction was part of the iBATIS Framework that the application was using. The developer changed the database command to execute the stored proc through JDBC instead of iBATIS and it no longer opened a DTC Transaction.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy