spatial « Oracle « JPA Q&A





1. How to use hibernate spatial execute oracle spatial function    forum.hibernate.org

Hello,everyone.I have a question.I can use hibernate spatial to query table which have a geometry column in table,but if i want to execute some oracle spatial function(like sdo_buffer....).How can we do ?I try to use "createSQLQuery" function ,but it throw a exception,which is "No Dialect mapping for JDBC type: 2002".Please help me,Thanks.If give me some code of demo,that is great.

2. Integration of Oracle Spatial into Hibernate    forum.hibernate.org

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 / ...

3. How to use Hibernate with Oracle 9 Spatial geometries?    forum.hibernate.org

Hibernate version: 2.1.6 Name and version of the database you are using: Oracle 9.2.0.5 Spatial Hello, I'm fairly new to Hibernate and read basically that it is possible to have custom UserTypes. Nevertheless I wondered if anyone in this forum already has implemented a UserType for the Oracle spatial geometry objects. There are two interesting types: oracle.spatial.geometry.JGeometry which is the concrete ...

4. HQL and Oracle spatial functions problem in Hibernat 3    forum.hibernate.org

Sorry, I posted too soon. Yes, the above linked bug entry is no bug and is not as related to my problem as I thought at first. However, using the classic the classic hql parser seems to do the trick. Unfortunately, the functions we have to use (as anyone else who uses Oracle Spatial) have dots in their names. If you ...

5. Using Hibernate with (Oracle) Spatial    forum.hibernate.org

Hi, My company is looking at using Hibernate and Oracle Spatial but I can't find much information on mixing the two together. So let's start with the questions 1) Has anyone done something like this before? How well did it work? 2) How well does Hibernate support the SDO_GEOMETRY dataypes? From what I can see, I have use UserTypes to implement ...