Error while trying to save a point to Postgres DB using Postgis

Question

My Entity class

@Type(type = "org.hibernate.spatial.GeometryType")
private Point location;

My spring boot configuration

spring.jpa.database=POSTGRESQL
spring.datasource.platform=postgres
spring.jpa.show-sql=true
#spring.jpa.hibernate.ddl-auto=validate
spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.url=****
spring.datasource.username=***
spring.datasource.password=**
spring.jpa.database-platform=org.hibernate.spatial.dialect.postgis.PostgisDialect

I get the following error while trying to save.

ERROR: column "location" is of type point but expression is of type bytea Hint: You will need to rewrite or cast the expression. Position: 154

Jendrusk · Accepted Answer · 2017-03-17 08:27:05Z

1

Seems like You're trying to store postgis geometry(point) data type into field which data type is postgresql point. They are not the same

answered Mar 17, 2017 at 8:27

Jendrusk

8135 silver badges9 bronze badges

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

2 Comments

Gulzar Hemani Over a year ago

Thanks so how do I represent the postgis point type in my entity pojo using spring JPA.

Jendrusk Over a year ago

Maybe try from the other way - change data type of column in database into geometry

Collectives™ on Stack Overflow

Error while trying to save a point to Postgres DB using Postgis

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related