com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.

Google Groups | Unknown author | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 1

    ERROR web[o.s.s.d.m.DatabaseMigrator] Fail to execute database migration: org.sonar.db.version.v60.CleanUsurperRootComponents

    Google Groups | 7 months ago | Unknown author
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.
  2. 0

    [ANN] SonarQube 6.0 RC1 is now available

    Google Groups | 7 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.
  3. 0

    Error during upgrade, dot_containers

    Google Groups | 6 months ago | David Petersheim
    com.microsoft.sqlserver.jdbc.SQLServerException: The object 'dot_containers' does not exist or is invalid for this operation.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    This is more of a question but could be ultimately a bug... So here is the story, trying to save a Geometry (as I understand Geography is not yet supported) into a MSSQL db. Here is the relevant mapping, which seems to create the table as expected: {code} import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; import com.vividsolutions.jts.geom.Point; @Entity @Table(name = "distance_holder") public class DistanceHolder { @Id @GeneratedValue(strategy = GenerationType.AUTO) private long id; @Column(name = "name") private String name; @Column(columnDefinition = "Geometry") private Point position; {code} But then how do I insert via jpa (spring-data-jpa in case it matters) to such a table: {code} DistanceHolder holder1 = new DistanceHolder(); holder1.setName("Some-Street"); GeometryFactory factory = new GeometryFactory(new PrecisionModel(), 4326); Coordinate coord1 = new Coordinate(46.977105, 28.874498); // that's my house coords Point someStreet = factory.createPoint(coord1); someStreet.setSRID(4326); holder1.setPoint(someStreet); {code} The exception thrown is : {code} com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.ArgumentException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 999999. System.ArgumentException: . at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) {code}

    Hibernate JIRA | 10 months ago | erabii
    com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.ArgumentException: 24100: The spatial reference identifier (SRID) is not valid. SRIDs must be between 0 and 999999. System.ArgumentException: .
  6. 0

    How do I deploy Activiti to Tomcat to use an MSSQL database and update the schema on startup?

    Stack Overflow | 3 years ago | Greg
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "ACT_RU_TASK" because it does not exist or you do not have permissions.

    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 "Danish_Norwegian_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
    2. com.microsoft.sqlserver
      SQLServerException.makeFromDatabaseError
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
      1 frame