Not an expert on Oracle Spatial, but I think you should be able to run this via SQLTemplate query:
http://cayenne.apache.org/doc30/sqltemplate-query.html Andrus On Sep 28, 2010, at 2:11 PM, ЄЖЄRSoN CმStმNЄDმ S wrote: > Hello everyone, > > I am newby in Cayenne 3.0, I would like to know if it is possible to > structure a query as follow using cayenne (these are SDO fuction of ORACLE). > > SELECT SDO_GEOM.SDO_MIN_MBR_ORDINATE(c.geometry, m.diminfo, 1) as xmin, > SDO_GEOM.SDO_MAX_MBR_ORDINATE(c.geometry, m.diminfo, 1) as xmax, > SDO_GEOM.SDO_MIN_MBR_ORDINATE(c.geometry, m.diminfo, 2) as ymin, > SDO_GEOM.SDO_MAX_MBR_ORDINATE(c.geometry, m.diminfo, 2) as ymax > FROM TABLE c, user_sdo_geom_metadata m > WHERE m.table_name = 'TABLE' AND m.column_name = 'GEOMETRYCOLUMN'; > AND c.KEY= 'XXXX'; > > In case that it would not be viable directly from a query, which is the best > way implementing a query like that?, maybe calling a procedure in PL/sql, i > guess. > > is it there some documentation source about SDO Oracle & Cayenne? > > Thanks for your help > > > EmeCas
