java.sql.SQLException: ORA-00904: "MDSYS"."OGC_WITHIN":

[Davis Ford]

Hi,

I have the following code:

testGeom = new WKTReader().read("POLYGON ((10 1, 10 5, 13 1, 13 5, 10 1))");
   Criteria testCriteria = session.createCriteria(GeofenceImpl.class);
   testCriteria.add(SpatialRestrictions.within("geometry", testGeom));

   list = testCriteria.list();

I'm using

<prop key="hibernate.dialect">org.hibernatespatial.oracle.OracleSpatial10gDialect</prop>

but with Oracle 9i.

I get this when I execute:

Caused by: java.sql.SQLException: ORA-00904: "MDSYS"."OGC_WITHIN":
invalid identifier

Any clue?

Thanks


--
Zeno Consulting, Inc.
home: http://www.zenoconsulting.biz
blog: http://zenoconsulting.wikidot.com
p: 248.894.4922
f: 313.884.2977
_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

[Karel Maesen]

Hi,

On 06 Feb 2009, at 17:28, Davis Ford wrote:
> Caused by: java.sql.SQLException: ORA-00904: "MDSYS"."OGC_WITHIN":
> invalid identifier
>
> Any clue?
>

I suggest you enable show_sql, copy the SQL generated by Hibernate/
Hibernate Spatial and then try to get the SQL working in a tool such  
as SQL*Plus.

The OGC_* functions are not really documented by Oracle so it is  
difficult for me to determine which functions are available in what  
versions of Oracle. You could try to inspect the user_source metadata  
view in Oracle to see what functions are available. All OGC-compliant  
functions are prefixed with 'OGC_'.

Regards,

Karel Maesen





_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users