Hibernate Spatial is a generic extension to Hibernate for handling geographic data. Hibernate Spatial is open source and licensed, like Hibernate, under the LGPL license. Hibernate Spatial allows you to deal with geographic data in a standardized way. It abstracts away from the specific way your database supports geographic data, and provides a standardized, cross-database interface to geographic data storage and query functions.
Questions tagged [hibernate-spatial]
161 questions
1
vote
1 answer
How to change Geometry object Datatype from polygon object datatype in HibernateSpatial API?
Trying to store Polygon shape in database with HibernateSpatial API. I have followed this tutorial to store values. I am using Mysql as my database server. So Made some couple of changes for my scenario. Getting the following ERROR to store it in…
ArunRaj
- 1,780
- 2
- 26
- 48
1
vote
1 answer
Get distance and Domain attribute in same query with Hibernate and PostGIS
I am using Hibernate, Postgre, PostGIS and Grails.
To search all the users within given radius I am using HibernnateSpetial and all works fine.
def criteria = sessionFactory.currentSession.createCriteria(User)
criteria.createAlias('location',…
manish
- 152
- 2
- 16
1
vote
2 answers
Best way to convert JTS Geometry from 3D to 2D
We are importing a Multi-Polygon Shapefile with 3D coordinates into oracle spatial using JTS Geometry Suite, GeoTools (ShapefileDataStore) and Hibernate Spatial. In Oracle Spatial we want them to be stored in 2D.
The onyl (and very slow) approach I…
fischermatte
- 3,327
- 4
- 42
- 52
1
vote
1 answer
Hibernate Spatial - Throws UnsupportedOperationException trying to load Oracle geometry
I am currently working with a colleague in transfering a Java application over to use Hibernate 4. As part of that work, we need to be able to load Ocracle geometry data into the Java application. However, when we try and load the geometry, we get a…
Ocracoke
- 1,718
- 3
- 24
- 38
1
vote
0 answers
Useing hibernate reverse engineering with hibernate-spatial, postgis and custom nameing strategy
I'm searching for an example to use hibernate reverse engineering for an existing postgis database (http://code.google.com/p/indicia/) for usage with hibernate-spatial and a custom naming strategy (because tables are plural with underscores in the…
dve
- 371
- 2
- 16
1
vote
1 answer
How to make a request factory non-transportable type transportable?
According to this answer: Is com.vividsolutions.jts.geom.Geometry directly transportable using requestfactory? Geometry is ( a particular case of a type that is ) non- transportable using requestfactory.
So then would this work? :
@Entity
public…
osh
- 1,191
- 4
- 13
- 21
1
vote
1 answer
Specifying index method when using @Index annotation
I'm using (spatial) hibernate annotations to create a schema for a spatial application that is implemented on top of PostGIS. When creating the database schema from my annotated classes, I'm in need to create spatial indexes for speeding up spatial…
tbl
- 771
- 3
- 11
1
vote
1 answer
Get hibernate-spatial up and running in play framework
I am taking my first steps with play 2.1, so I did the JavaTodoList Tutorial on the playframework website. Everything worked as expected.
Next I changed the todolist to use a postgresql database running on my dev box. All I had to do was to change…
Jürgen Zornig
- 1,174
- 20
- 48
0
votes
1 answer
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?
Here is the relevant part of the Entity class…
S.N
- 2,157
- 3
- 29
- 78
0
votes
0 answers
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 getting below…
Urman Ratneshwar
- 55
- 9
0
votes
1 answer
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 type. While trying to start up the application after…
Urman Ratneshwar
- 55
- 9
0
votes
1 answer
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.SQLServerDriver
dialect:…
lujjas
- 68
- 9
0
votes
1 answer
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(ST_GeomFromText('POINT(:userLongitude…
JavDevHar
- 1
- 1
0
votes
1 answer
Micronaut projection DTO type conversion
given the entity model below:
@Entity(name = "Accounts")
open class AccountEntity(
@field:Id
@field:GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "accounts_sequence_generator")
@field:SequenceGenerator(name =…
JerryThePineapple
- 63
- 8
0
votes
1 answer
Error: Invalid endian flag value encountered with Hibernate 6 and Spring Boot 3
I am having some problems with Hibernate Spatial 6 with PostGIS and Spring Boot 3.0. This project I have taken and upgraded to SB 3.0 SNAPSHOT: https://github.com/murphye/spring-boot-postgis/tree/3.0
I am getting this error when I try to run a…
Eric Murphy
- 61
- 6