postgis « Query « JPA Q&A





1. JPA/Hibernate Native Queries do not recognize Parameters    stackoverflow.com

I am using Hibernate/JPA to execute native PostGIS queries. The problem with these queries is that they need parameters that are not of the classical X = 'value' form. For example, the ...

2. PostGIS + JPA + Hibernate - Centroid Query    stackoverflow.com

Hello fellow overflowers! I was hoping I could get some help with this query. I am still rather new to hibernate and JPA and do not quite understand how to ...

3. PSQLException with native Postgis Query    forum.hibernate.org

Hello, I am new to the hibernate's world, and I wanted to take advantage of this short note to congratulate the authors, I'm really impressed with the quality of your work ... I get a PSQLException when I try to run a native query: Code: @NamedNativeQuery( name="Flow.getWithin", query="SELECT " ...

4. How to use operators like "&&" in postgis    forum.hibernate.org

Hi, How to use operators like "&&" in postgis queries? Hibernate version: 3 Name and version of the database you are using: Postgres 8.1 Plus Postgis 1.0 The generated SQL (show_sql=true): Never generates it as desired... In Postgis you can perform geometrical queries like this one: select * from spatial as s1 where s1._Geom && setSRID( cast('BOX3D(1 2, 3 4)'as box3d) ...