openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-240) Persistent field mappings to database supported XML columns
Date Thu, 19 Jul 2007 02:51:06 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12513792
] 

Catalina Wei commented on OPENJPA-240:
--------------------------------------

We have committed the patch for the feature OPENJPA-240.
Current Limitations/Restrictions:
- Query support for field mapping to XMLColumn is only allowed to appear in simple comparison
predicates.
- To enable this function, the property  "openjpa.MetaDataRepository"  must explicitly set
to     
    "org.apache.openjpa.jdbc.meta.XMLMappingRepository"
- XML schema with default namespace declaration at document level should work fine, but the
namespace decl at  element level will fail to qualify (the predicate always evaluate to false,
so query result is empty).

Remaining work items:
1. support namespace at element level.
2. Allow other type of predicates in addition to simple comparison predicates.
3. if no objection, make XMLMappingRepository as the default metadata repository (string set
in JDBCConfigurationImpl.java)
4. when defecting a field having XML bindings, set default strategy to   XMLValueHandler without
requiring  explicit @Strategy annotation in the entities

Documentation:
We are working on converting the attached word doc to xml document, then merge that into OpenJPA
developer's manual (we expect this should be done within a week).

Cleanup  testcase - TestXMLCustomerOrder.java:
- remove System.out.printlns
- assert  generated sqls against the answer set (TestXMLCustomerOrder.db2, TestXMLCustomerOrder.oracle,
TestXMLCustomerOrder.sqlserver) rather than dumping it out to  a file  (./TestXMLCustomerOrder).

Catalina

> Persistent field mappings to database supported XML columns
> -----------------------------------------------------------
>
>                 Key: OPENJPA-240
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-240
>             Project: OpenJPA
>          Issue Type: New Feature
>          Components: jdbc
>            Reporter: Catalina Wei
>         Attachments: jpa1.0.0-xmlmapping.r555694.patch, OpenJPAXMLMapping.doc
>
>
> Many database systems such as DB2 version 9, Oracle 10g, and SQLServer 2005 have support
for XML column types. XML documents can be stored natively in the XML columns in the database.
> What is OpenJPA's position of supporting the XML columns ?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message