[jira] Commented: (OPENJPA-240) Persistent field mappings to database supported XML columns

["Catalina Wei (JIRA)" <ji...@apache.org>]

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

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

This feature has a dependency on JAXB XML Bindings (jaxb2.1 or later version). A J2EE application is required to generate JAXB XML bindings from XML documents' schema definition (.xsd files). The persistent fields that map to XML columns will use XML marshalling to write the data to XML column and unmarshalling to retrieve the data from XML column. The XML marshalling and unmarshalling work is performed by the XmlValueHandler (org.apache.openjpa.xmlmapping.XmlValueHandler).

The required annotations on persistent field that maps to an XML column are:
•	@Persistent
•	@ Stratedy("org.apache.openjpa.xmlmapping.XmlValueHandler")

Jere is an example, Order entity's shipAddress maps to XML Column shipAddress of Order Table:
@Entity
Class Order {
     @Persistent
     @Strategy("org.apache.openjpa.xmlmapping.XmlValueHandler")
      Address shipAddress;
     @Id ...
  }

The runtime requirement of JAXB  is version 2.1 or later.
 
Detailed documentation and test cases will soon be made available.



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