jdbc and distributed transaction defaults

  • 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

  • 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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply