com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:4200000012. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:1964) ~[sqljdbc4.jar:na] at weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_jdbc_SQLServerConnection.rollback(Unknown Source) ~[wlfullclient.jar:12.1.1.0] Connection is closed. Then the next time the application attempts to get a connection from the data source, the following error is thrown: java.sql.SQLException: Failed to setAutoCommit to true for pool connection: First we got The server failed to resume the transaction. Desc:4200000012., then we got The server failed to resume the transaction. Desc:4200000012.

Stack Overflow | Mike | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Failed to setAutoCommit to true - Weblogic 12 - SQL Server

    Stack Overflow | 3 years ago | Mike
    com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:4200000012. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:1964) ~[sqljdbc4.jar:na] at weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_jdbc_SQLServerConnection.rollback(Unknown Source) ~[wlfullclient.jar:12.1.1.0] Connection is closed. Then the next time the application attempts to get a connection from the data source, the following error is thrown: java.sql.SQLException: Failed to setAutoCommit to true for pool connection: First we got The server failed to resume the transaction. Desc:4200000012., then we got The server failed to resume the transaction. Desc:4200000012.

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      The server failed to resume the transaction. Desc:4200000012. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1756) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1761) ~[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:1964) ~[sqljdbc4.jar:na] at weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_jdbc_SQLServerConnection.rollback(Unknown Source) ~[wlfullclient.jar:12.1.1.0] Connection is closed. Then the next time the application attempts to get a connection from the data source, the following error is thrown: java.sql.SQLException: Failed to setAutoCommit to true for pool connection: First we got The server failed to resume the transaction. Desc:4200000012., then we got The server failed to resume the transaction. Desc:4200000012.

      at weblogic.jdbc.wrapper.PoolConnection.init()
    2. weblogic.jdbc.wrapper
      PoolConnection.init
      1. weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:70)[wlfullclient.jar:12.1.1.0]
      1 frame
    3. weblogic.jdbc.common
      RmiDataSource.getConnection
      1. weblogic.jdbc.common.internal.RmiDataSource.getPoolConnectionObj(RmiDataSource.java:639)[wlfullclient.jar:12.1.1.0]
      2. weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:478)[wlfullclient.jar:12.1.1.0]
      3. weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:558)[wlfullclient.jar:12.1.1.0]
      4. weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:518)[wlfullclient.jar:12.1.1.0]
      5. weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:511)[wlfullclient.jar:12.1.1.0]
      5 frames