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