Post reply

jdbc and distributed transaction defaults

  • April 12, 2016 at 2:46 pm

    #317959

    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

    #1884445

    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