Eclipse Community Forums: EclipseLink » Support for XML column types?

Home » Eclipse Projects » EclipseLink » Support for XML column types?

Support for XML column types? [message #634317]

Thu, 21 October 2010 05:18

Eclipse User

Hello,

OpenJPA supports the mapping of entity properties, which have JAXB binding annotations as described here. I would like to know whether a similar feature is planned for EL in the near future?

thanks,
marco

Re: Support for XML column types? [message #634447 is a reply to message #634317]

Thu, 21 October 2010 14:13

Eclipse User

EclipseLink has support for XMLType in Oracle using the DirectToXMLTypeMapping, but there is no annotation support for this mapping, nor support for other database platforms. Although I think you can just map any XMLType just as a String and have it work.

EclipseLink Expressions support XPath based query extensions, but there is no JPQL support for these functions as of yet. You could potentially use the generic FUNC operator in JPQL (as of EclipseLink 2.1).

You could define an EclipseLink Converter to marshal an object to/from XML in a mapping.

Please log an enhancement request for this feature and vote for it.

Re: Support for XML column types? [message #637762 is a reply to message #634447]

Mon, 08 November 2010 13:18

Eclipse User

thanks for your hints. I went for the converter option and it works quite well.

For defining the target field type in DB (I need a clob) I read on the mailinglists that I have to override initialize(DatabaseMapping mapping, Session session) and specifiy the type there via mapping.getField().setSQLType(Types.CLOB). However, this (and some variations to setting the field type) didn't work out and the generated type in the DB was always varchar.

finally, I tried ((DirectToFieldMapping)mapping).setFieldClassification(Class Constants.CLOB);, which delivered the expected results.

Is this the right way to define the target type or should mapping.getField().setSQLType(Types.CLOB) also work out?

thanks,
marco

Re: Support for XML column types? [message #638512 is a reply to message #637762]

Thu, 11 November 2010 09:41

Eclipse User

The sqlType on the DatabaseField defines how it is accessed through JDBC.

The type used for schema creation is derived from the type (setType(Clob.class)). Or can be defined directly by the columnDefinition (setColumnDefinition("CLOB")).

Re: Support for XML column types? [message #638521 is a reply to message #638512]

Thu, 11 November 2010 10:03

Eclipse User

thanks, that worked

Previous Topic:	Inheritance bug?: super class instantiated instead of sub class
Next Topic:	Handling files using lob in entity

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 23:09:50 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter