Spring Boot with the usage of Hibernate Spatial in MySQL Database Issue - Cannot set the value to Point

Question

I have a problem to set latitude and longitude to Point with the usager of Hibanate Spatial feature in Spring Boot.

I cannot set it as I guess there is a problem in columnDefinition.

How can I fix it?

Here is the relevant part of the Entity class shown below

@Column(name = "POINT", columnDefinition = "geometry(Point,4326)")
private Point point;

public void setPoint(double latitude, double longitude) {
    Coordinate coordinate = new Coordinate(latitude, longitude);
    GeometryFactory geometryFactory = new GeometryFactory();
    this.point = geometryFactory.createPoint(coordinate);
}

Here is the database configuration part of application.yml

spring:
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.MySQLDialect
        format_sql: true
    hibernate:
      naming:
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

DASH · Accepted Answer · 2023-07-17 20:10:04Z

0

You don't need to specify column definition.Specifying the datatype as Point in your entity model is enough.

Please use the standard setter for the point field and use a utility function to calculate point using the coordinates.

Refer the answer below Use PostGIS geography point with hibernate spatial 5 in spring boot

answered Jul 17, 2023 at 20:10

DASH

1325 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Sercan Noyan Germiyanoğlu Over a year ago

I want to specify its defination. Is ST_GeomFromText(Point, 4326) enough for definition? Can you help me solve the issue.

DASH Over a year ago

Specifying the definition is fine. In order to isolate the issue, try with no definition first. Also change setter for the point field to public void setPoint(Point point){ this.point=point}.

Sercan Noyan Germiyanoğlu Over a year ago

@Column(name = "POINT", columnDefinition = "ST_GeomFromText(Point, 4326)") private Point point; Is it right? Why don't I use geometry(Point,4326) in the Point. Can you explain it?

Sercan Noyan Germiyanoğlu Over a year ago

Which one is right? geometry(Point,4326) or ST_GeomFromText(Point, 4326)

DASH Over a year ago

geometry(Point,4326) does not rely on any specific PostGIS functions. So I would prefer that. Try changing the setter first. i.e public void setPoint(double latitude, double longitude) {} to public void setPoint(Point point) {this.point=point} and use a util method to calculate point and pass to setter. This should work.

|

Collectives™ on Stack Overflow

Spring Boot with the usage of Hibernate Spatial in MySQL Database Issue - Cannot set the value to Point

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related