[
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.
