locked
SQL2005 JDBC Driver - Transaction problem RRS feed

  • Question

  • HI,

      We are migrating SQL2000 to SQL2005, we are using sql2005 jdbc driver 1.0.

      I got this error "com.microsoft.sqlserver.jdbc.SQLServerException: Server failed to resume the transaction", when my application calls a stored procedure which is a transaction.

      Does anyone know what could be the problem, how to fix it?

      Thanks in advance. 

    Tuesday, December 19, 2006 10:28 PM

Answers

  • Thanks Jaaved.

    I fixed the problem I had, The error was caused by an output parameter.

    Cathie

    Friday, January 5, 2007 8:33 PM

All replies

  • Hi Cathie,

    Are you performing a Local or a XA transaction? A code sample would be great in debugging this. I am especially interested in the order of Transaction API calls that are made. Does this problem also reproduce with the v1.1 JDBC driver. You can find it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en.

    Regards,

    Jaaved Mohammed

     

    Tuesday, January 2, 2007 5:23 AM
  • Also you should consider using our 1.1 version of the JDBC driver. We have made some changes to our transactions behvaior in this driver.

    Mugunthan

    Wednesday, January 3, 2007 10:50 PM
  • Thanks Jaaved.

    I fixed the problem I had, The error was caused by an output parameter.

    Cathie

    Friday, January 5, 2007 8:33 PM
  • Thank you Mugunthan.

    I was using jdbc1.1 driver. The problem was caused by an output parameter.


     

    Friday, January 5, 2007 8:35 PM