Re: A SDO Query with cayenne

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Sep 28 2010 - 15:41:15 UTC

  • Next message: Borut Bolčina: "Re: Cayenne vs Hibernate Comparison"

    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

    This archive was generated by hypermail 2.0.0 : Tue Sep 28 2010 - 15:41:50 UTC