Sign in
 

none
Distributed Transaction Error

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi

    Getting the following error when I try to get a distributed transaction via JDBC:

    javax.transaction.xa.XAException: Failed to initialize the stored procedure xp_sqljdbc_xa_init, status: -3. The error message is: *** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***.
        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:415)


    Using:
    SQLServer2000 on Windows 2003
    MS SQL SERVER 2005 JDBC Driver - 2.0
    Java 6.

    Installed as per the instructions and made SQL server distributed transaction aware - but no joy!

    Any help appreciated.

    Cheers
    jon
    Monday, December 08, 2008 4:10 PM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    So reviewed the install instructions - missing step:

    Select the Enable XA Transactions check box, and then click OK. This will cause a MS DTC service restart.

    So all is well and it works a treat....
    Tuesday, December 09, 2008 2:45 PM
    |