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)

Google Groups | Fabrice Bellingard | 5 months ago
  1. 0

    [ANN] SonarQube 6.0 RC1 is now available

    Google Groups | 5 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)
  2. 0

    [OpenJPA-users] Optimistic Lock Exception not thrown with @version - Grokbase

    grokbase.com | 8 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Trouble creating databas on a sql 2000 server

    opengts | 7 years ago | kernal69
    com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)
  6. 0

    [Sqoop-user] sqoop2 export to microsoft SQL server - supported jdbc connectors - Grokbase

    grokbase.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'SELECT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)

    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

      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)

      at org.jruby.javasupport.JavaMethod.invokeDirect()
    2. JRuby Main Maven Artifact
      JavaMethod.invokeDirect
      1. org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316)
      1 frame