This discussion is archived
2 Replies Latest reply: Dec 1, 2012 2:21 PM by 976846 RSS

Oracle spatial with hibernate

976846 Newbie
Currently Being Moderated
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?

Thanks,
M

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points