2 Replies Latest reply on Dec 1, 2012 10:21 PM by 976846

    Oracle spatial with hibernate

      We're trying to use Hibernate to do Oracle spatial queries. Specifically to do things like "get all spatial objects that fall within this search circle." Instead we're getting things that are near the border of the search circle, but not things near the interior. Trying to figure out if we're building the Hibernate query wrong or if this is just something Hibernate/Oracle spatial can't do together.

      We're building Hibernate Criteria with statements like: "sdo_relate({alias}.GEOMETRY_3D, [geometry goes here], 'mask=anyinteract') = 'TRUE'"

      Anyone know of any common pitfalls when trying to do something like this, or known issues we can work around somehow?