168 questions
0 votes
0 answers
62 views
Hibernate spatial custom type is overriden by the default Hibernate spatial type
I have a custom Oracle Hibernate Dialect with a custom Oracle spatial type. This type is supposed to replace the standard SDOGeometryType. The purpose of this custom type is to handle complex arcs in ...
0 votes
1 answer
195 views
SpringBoot not returning locationtech Geometry
Trying to return an object containing a Geometry through a REST interface using Spring. While the other fields are returned correctly, the geometry field comes out looking like: "location":{&...
0 votes
1 answer
125 views
OpenLiberty + Hibernate spatial + Postgis issue
I'm trying to write a geometry to a Postgres database with Postgis extension enabled together with OpenLiberty 24.0.0.11 and Hibernate-spatial 6.6.3.Final, but get the following error: jakarta....
1 vote
1 answer
475 views
Jpa with hibernate spatial and postgis not working
application.properties: spring.datasource.url=jdbc:postgresql://localhost:5432/test_postgis spring.datasource.username=postgres spring.datasource.password=1234 spring.datasource.driver-class-name=org....
0 votes
1 answer
385 views
PostGIS migration to Hibernate 6
I'm trying to migrate to Spring Boot 3 (and hibernate-spatial:6.4.1.Final) So before migration i have following lines in my @Entity describing a column in the table storing a MultiLineString geometry: ...
0 votes
1 answer
476 views
Hibernate 6.3 creates bytea column type instead of geometry
I basically encounter the same problem described in this post: hibernate-spatial-4.0 creates bytea column type instead of geometry According to the hibernate docs the type mapping of a jts Geometry ...
0 votes
1 answer
89 views
Can I use `ST_Buffer` with hibernate and MySql?
I have a question about hibernate-spatial. (I'm using hibernate version 6.1.7.Final) The official hibernate documentation says that MySql's St_Buffer is not supported, @Query(""" ...
0 votes
1 answer
723 views
Spring Boot with the usage of Hibernate Spatial in MySQL Database Issue - Cannot set the value to Point
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? ...
-1 votes
1 answer
642 views
Data truncation: Cannot get geometry object from data you send to the GEOMETRY field
hi i'm trying to insert and read geo data(POINT) to mySQL DB. I am using JPA. I got latitude and longitude from the frontend and I made a String like POINT(10 20) as wkt. then by using WKTReader, I ...
3 votes
2 answers
1k views
PostGIS Functions in hibernate spatial 6 migration
First Issue: I have an existing code written for hibernate spatial 5 to find records within given radius, which works fine. I am in the process of migrating the code hibernate-spatial 6.1.7.Final. But ...
0 votes
1 answer
5k views
SpringBoot 3, hibernate-spatial 6, PostGIS:: java.lang.ClassNotFoundException: org.hibernate.dialect.PgJdbcHelper
I am trying to migrate my current spring boot 2 application to 3. I am using PostGIS (I have not set explicit dialect so it uses org.hibernate.dialect.PostgreSQLDialect) to use the geometry column ...
2 votes
0 answers
462 views
Micronaut with Hibernate Spatial types deserialization
The essence of the question is to serialize and deserialize the Geometry class from Hibernate Spatial in the Micronaut framework. This is how the field is represented in my entity. import org....
0 votes
1 answer
129 views
SQL Sequence mapping - SqlServer2012SpatialDialect, Grails 4, Hibernate 5 compatibility
So far in the configuration file (application.yml) hibernate-dialect has been set as follows: dataSource: pooled: true jmxExport: true driverClassName: com.microsoft.sqlserver.jdbc....
0 votes
1 answer
223 views
PostGis invalid geometry when using ST_GeomFromText
i am using postgis with spring boot hibernate jpa. Code in Repository: @Query(value = "select {h-schema}ref_plz_geom.plz from {h-schema}ref_plz_geom WHERE ST_Contains(geom, ST_Transform(...
2 votes
1 answer
237 views
Incorrect result using Geometry.reverse() for XYM coordinates
We are using jts-core (org.locationtech.jts:jts-core:jar:1.19.0) together with hibernate-spatial (org.hibernate:hibernate-spatial:jar:5.6.10.Final:compile) to retrieve geometries with measured ...