PK64012: SQLSERVER SQLEXCEPTION:THE SERVER FAILED TO RESUME THE TRANSACTION

APAR status

• Closed as unreproducible in next release.

Error description

• Customers who installed WebSphere Application Server fixpack
  6.1.0.15 and encounter this exception:
  
  java.sql.SQLException: [IBM][SQLServer JDBC
  Driver][SQLServer]The server
  failed to resume the transaction. Desc:3500000001.
  
  It seems the embedded SQLServer JDBC driver, versions
  3.6 and 3.7 do not allow a transaction within a stored
  procedure.
  

Local fix

• Back level JDBC driver.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server who use WebSphere Connect JDBC Driver*
  ****************************************************************
  * PROBLEM DESCRIPTION: The embedded SQLServer JDBC driver,     *
  *                      versions 3.6 and 3.7 do not allow a     *
  *                      transaction within a stored procedure.  *
  *                                                              *
  *                      java.sql.SQLException:                  *
  *                       IBM  SQLServer JDBC                    *
  *                      Driver  SQLServer The server            *
  *                      failed to resume the transaction.       *
  *                      Desc:3500000001                         *
  *                                                              *
  *                      The use of transaction with in stored   *
  *                      procedures in not supported by Data     *
  *                      Direct.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There will be no code change under this APAR, however in order
  to allow users time to fix application code we will provide
  the 3.5 version of the driver upon request.
  You can use this version of the driver while you upgrade
  application code to not use transactions within stored
  procedures.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R60A PSY

     UP

• R60H PSY

     UP

• R60I PSY

     UP

• R60P PSY

     UP

• R60S PSY

     UP

• R60W PSY

     UP

• R60Z PSY

     UP

• R61A PSY

     UP

• R61H PSY

     UP

• R61I PSY

     UP

• R61P PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R61Z PSY

     UP