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
  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.
  2. 0

    [ANN] SonarQube 6.0 RC1 is now available

    Google Groups | 4 months ago | Fabrice Bellingard
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the > collation conflict between "SQL_Latin1_General_CP1_CS_AS" and > "Latin1_General_CS_AS" in the equal to operation. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372) > ~[sqljdbc42.jar:na] > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159) > ~[sqljdbc42.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284) > ~[sqljdbc42.jar:na] > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > ~[commons-dbcp-1.4.jar:1.4] > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > ~[commons-dbcp-1.4.jar:1.4] > at org.sonar.db.version.SelectImpl.scroll(SelectImpl.java:74) > ~[sonar-db-6.0-RC1.jar:na] > at org.sonar.db.version.MassUpdate.execute(MassUpdate.java:91) > ~[sonar-db-6.0-RC1.jar:na] > at > org.sonar.db.version.v60.CleanUsurperRootComponents.fixSnapshotScopeAndQualifier(CleanUsurperRootComponents.java:54) > ~[sonar-db-6.0-RC1.jar:na] > at > org.sonar.db.version.v60.CleanUsurperRootComponents.execute(CleanUsurperRootComponents.java:36) > ~[sonar-db-6.0-RC1.jar:na] > at org.sonar.db.version.BaseDataChange.execute(BaseDataChange.java:45) > ~[sonar-db-6.0-RC1.jar:na] > at > org.sonar.server.db.migrations.DatabaseMigrator.executeMigration(DatabaseMigrator.java:95) > ~[sonar-server-6.0-RC1.jar:na] > at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) ~[na:na] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > ~[na:1.8.0_60] > at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_60] > at > org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)
  3. 0

    [ANN] SonarQube 6.0 RC1 is now available

    Google Groups | 4 months ago | Fabrice Bellingard
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the >> collation conflict between "SQL_Latin1_General_CP1_CS_AS" and >> "Latin1_General_CS_AS" in the equal to operation. >> at >> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372) >> ~[sqljdbc42.jar:na] >> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159) >> ~[sqljdbc42.jar:na] >> at >> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284) >> ~[sqljdbc42.jar:na] >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >> ~[commons-dbcp-1.4.jar:1.4] >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >> ~[commons-dbcp-1.4.jar:1.4] >> at org.sonar.db.version.SelectImpl.scroll(SelectImpl.java:74) >> ~[sonar-db-6.0-RC1.jar:na] >> at org.sonar.db.version.MassUpdate.execute(MassUpdate.java:91) >> ~[sonar-db-6.0-RC1.jar:na] >> at >> org.sonar.db.version.v60.CleanUsurperRootComponents.fixSnapshotScopeAndQualifier(CleanUsurperRootComponents.java:54) >> ~[sonar-db-6.0-RC1.jar:na] >> at >> org.sonar.db.version.v60.CleanUsurperRootComponents.execute(CleanUsurperRootComponents.java:36) >> ~[sonar-db-6.0-RC1.jar:na] >> at org.sonar.db.version.BaseDataChange.execute(BaseDataChange.java:45) >> ~[sonar-db-6.0-RC1.jar:na] >> at >> org.sonar.server.db.migrations.DatabaseMigrator.executeMigration(DatabaseMigrator.java:95) >> ~[sonar-server-6.0-RC1.jar:na] >> at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) ~[na:na] >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> ~[na:1.8.0_60] >> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_60] >> at >> org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue when sqoop from MSSQL to Hive - Grokbase

    grokbase.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:fab8ea67-c7e8-4601-9400-eedd21ac573e at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:60) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2229) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
  6. 0

    JDBC connection to SQL Server: login failed for user x

    Stack Overflow | 4 years ago | Sam
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'samxtest'. ClientConnectionId:2344af..... at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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