Re: XMLTYPE ?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Dec 08 2004 - 09:36:40 EST

  • Next message: René Kulschewski: "AW: XMLTYPE ?"

    > Hello,
    >
    > I have a table (in Oracle) containing a field of type "XMLTYPE". The
    > Modeler shows me after reengineering a field type "OTHER" for the
    > dbEntity and it is empty for the objEntity.
    >
    > Is the XMLTYPE supported ? How must i map it ?
    >
    > Thanks and best regards
    > René

    As XMLTYPE is Oracle-specific extension and doesn't seem to be directly
    supported via JDBC, it has to be read using Oracle dirver API (yikes!):

    http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsp/xmltype/GetXMLTypeVal.java.html

    To integrate this to Cayenne (and provide mapping to any Java class you
    want) you'd have to implement an ExtendedType:
    http://objectstyle.org/cayenne/userguide/access-stack/extended-types.html

    Let me know if this works. I wouldn't mind adding XMLTYPE ExtendedType to
    Cayenne OracleAdapter.

    Andrus

    This archive was generated by hypermail 2.0.0 : Wed Dec 08 2004 - 09:36:42 EST