Integration of Oracle Spatial into Hibernate

tfriebe · **Posted:** Fri Apr 02, 2004 9:59 am

Hi,
has anyone experience in extending hibernate 2.1 to use geometry types and access spatial data stored with Oracle Spatial Cartridge (aka SDO) 8.1.6 or higher?
And what is the recommended way to extend hibernate to support types such as 2-D point, line string, polygon?
Regards
Torsten

emmanuel · **Posted:** Fri Apr 02, 2004 12:59 pm

Implement a UserType or CompositeUserType I guess

tfriebe · **Posted:** Tue Apr 06, 2004 6:37 am

Thanks. Understanding that implementing these interfaces only cover the data types, where can I add new operations? Do I have to extend the HQL or can I use SQL function names in my queries?
Regards
Torsten

christian · **Posted:** Tue Apr 06, 2004 7:36 am

You can use arbitrary SQL functions in the WHERE clause in HQL, they will be passed to the underlying database via SQL.

ronlahav · **Joined:** Mon Oct 10, 2005 1:55 pm **Posts:** 12

Dear All
i will really appreciate any help!!!
Im using Nhibernate (you can answer also valid answer for hibernate) In order to map my classes for my application in Dot Net Using C#. My problem is that i use Oracle DB with SDO Class Library which enables me to do some geographical queries.
how can i map SDO geometry column / clacss member in to the database in order to make queries???
I will relly appreciate your help / code sample
Thnks alort