My Environment mysql 8.0.25 hibernate-core:5.4.32 hibernate-spatial:5.4.32 spring-boot2.5.4 java 8 What I did application.yml spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver ur...

We have been using H2 for our integration tests for quite some time. Now that H2 2.0.202 is out, we are trying to upgrade our codebase to it. We are unable to persist entities, that use java.util.U...

In a Spring Boot project, Java8, with hibernate-spatial and PostgresDB 9.4 <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-spatial</artifactId&gt...

After upgrading Hibernate-spatial to Version 5.0.0.CR2 the following declaration doesn't work anymore: @Column(columnDefinition = "geometry(Point,4326)") @Type(type = "org.hibernate.spatial.Geomet...

Dear stackoverflow readers, I'm currently working on an application that has the requirement to load specific items based on its coordinates. Example: I want all shops from coordinates x or within...

Given the query example here: http://www.hibernatespatial.org/tutorial-hs4.html Query query = em.createQuery("select e from Event e where within(e.location, :filter) = true", Event.class); query....

I am working on my first Spring Boot + Spring Data JPA + Hibernate 5 working on a PostgreSQL database. I have the following problem trying to map a field having point as data type (so I am using H...

I would like to rewrite the following query in a Predicate/Specification so that i can link them. this query filters all my defined OptEvent Entitys within a specific area @Query(value = "SELECT ...

I'm trying to run a simple query in Hibernate Spatial 4.0 on PostgreSQL 9.3. I have a number of objects in a table with latitude/longitude values, and I'm trying to query objects that fall within a...

I am using spring boot command line runner app, it hangs at PostGIS dialect, the below stack trace contains what's happening. Unable to understand what's going wrong, I have hibernate-spatial queri...

Here is my config now. I want to use hibernate spatial to work with postgis in production. spring: profiles: production datasource: platform: postgres url: jdbc:postgresql://192.168.99.100:54...

I am developing an location app with oracle spatial in Java. I am using hibernate 4.0 spatial for orm layer. I am new in spatial and i couldn't find best practise for hibernate spatial. My database...

Assume I have the following table CREATE TABLE foo ( id BIGSERIAL PRIMARY KEY, polygon GEOMETRY(POLYGON) ); and entity class @Table @Entity public class Foo { @Id @GeneratedValue(strategy...

I'm using postgresql, hibernate-spatial and postgis and expected to be able to use a SqlQuery to retrieve a Geometry object. However whenever I try to query a Point, Polygon or Geometry eg List l...

I'm trying to query spatial relations between my entities but keep getting this exception: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: ( near line 1, My entities ar...

I am developing a GIS application with java(Spring-4.1.5 + Hibernate-4.3.8) and OpenLayers. For this project I use GeoTools-13RC, HibernateSptial-4.3, jts-1.13 and jackson-2.5. In this project, I h...

My application is going to use the following technologies: Postgresql Postgis JPA/Hibernate Spring Spring Data JPA I understand (from the Hibernate Spatial documentation) that one has to use th...

I am new to Hibernate Spatial, and am trying to perform a simple query of objects within a given radius. I've created a number of entries in my database with properties corresponding to a latitude ...