com.microsoft.sqlserver.jdbc.SQLServerException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • [ANN] SonarQube 6.0 RC1 is now available
    via by Fabrice Bellingard,
  • Error during upgrade, dot_containers
    via by David Petersheim,
  • 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}
    via by erabii,
  • how to use Changed Data Capture?
    via by 574634,
  • No title
    via by Unknown author,
  • Set current database on source failed
    via by 574634,
    • 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(SQLServerException.java:217)

    Users with the same issue

    SteVio1989SteVio1989
    3 times, last one,
    Andreas HäberAndreas Häber
    120 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    82 more bugmates