I've managed to get HQL working with postgis... thanks to some help from the hibernate forums. Some of the spatial operators are working and some don't work.

This query for a specific geometry with operator "~=" works:

WHERE
GEOM ~= GeometryFromText('POINT(1 1 1)',-1);

This query finding all the geometries inside a box also works:

WHERE
GeometryFromText('BOX3D(1 1 1, 100 100 100)',-1) ~ GEOM;

This query using the overlaps operator "&&" does not work:

WHERE
GEOM && GeometryFromText('BOX3D(1 1 1, 100 100 100)',-1);

Nor does this work:

WHERE
GEOM @ GeometryFromText('BOX3D(1 1 1, 100 100 100)',-1);



Is there any way to quote these operators, "&&" and "@", to get them to pass through the HQL parser?

Dear rrdodes

From your emails to hibernate formus,I see that you can use PostGIS in Hibernate.
This have been a big problem for me. Can you send me some complete examples (including usertype and PropertyAccessor) or any thing that you think will be usefull?

I look forward to hearing you soon.

MRB
heenco2000@yahoo.com

you can define them as functions in your dialect.

(or simply just use native sql since these will anyhow only be usable on that one db)

Hi

I try to use some postgis functions like within, contains, overlaps, crosses in hibernate with HQL.

the actual SQL query looks like this.
List res = session.createSQLQuery("select within(" + pointstring + ", coordinates) from geoobjects;").addScalar("within", Hibernate.BOOLEAN).list();



can anybody give me en example in HQL?

read my previous answer - you can define special/custom functions in the Dialect.

where can I define my dialect?

by the way:

you life in switzerland? Do you speak german?
I'm from lucern.

http://www.hibernate.org/hib_docs/v3/re ... l-dialects

...and then just extend it and add your functions.

btw. in 3.2 you can do it in the mapping file or directly on the Configuration object.

...and yes my location is Neuchatel, Switzerland.

I do speak (some kind) of german, but my native tounge is Danish ;)