JPA XMLColumn mapping

1
JPA XMLColumn mapping

• JAXB dependency
• XML Schema xsd to JAXB XML bindings
• _at_XmlRootElement
• Required Annotations
• _at_Persistent
• _at_Strategy("org.apache.openjpa.jdbc.meta.strats.XML
  ValueHandler")
• CRUD

2
Query

• Simple comparisons
• Navigate single value path
• Examples
• "Select o from ProductOrders o where
  o.podetails.customer.name ?1"
• Select o from ProductOrders o where
  o.podetails.customer.type ?1

3
Sample query test can be found under openjpa

• openjpa-persistence-jdbc/src/test/
• java/org/apache/openjpa/persistence/xmlmapping
  .query/
• TestXMLCustomerOrder.java
• Generated SQL for differenct platforms
• TestXMLCustomerOrder.db2
• TestXMLCustomerOrder.oracle
• TestXMLCustomerOrder.sqlserver

4
Future Functionality

• Namespace declarations
• Other predicates
• Scalar functions
• Multi-valued