This content has been marked as final. Show 2 replies
You might consider using Hibernate Spatial (http://www.hibernatespatial.org/). It extends hibernate with spatial types (using JTS) and support Oracle. There is an API specifically for this kind of queries.
We are using the Geometry classes from Hibernate. Turns out our problem was with building the query geometry backwards -- clockwise vs counterclockwise.