Eclipse Community Forums: EclipseLink » Recommended way to store XML data with EL

Home » Eclipse Projects » EclipseLink » Recommended way to store XML data with EL

Wed, 16 June 2010 05:37

Eclipse User

Hi,

I am looking for a best practice solution for storing XML data in a database with EL. I receive an XML document from a WS (using Apache CXF) which is unmarshaled to an object structure using JAXB. After some processing, I would like to store the data in a MySQL db using JPA/EL. I don't need to query or manipulate the data later on - i.e., the data could be stored as a BLOB. I thought about marshaling the data to a byte[] or to a string (preferable) and store it as a property of an entity.
Is there any better solution supported by EL or should I go with the marshaling approach (if so, are there any major performance differences between marshaling to byte[] or string)?

Thanks in advance for your thoughts.

marco

Wed, 16 June 2010 10:21

Eclipse User

Hello Marco,

For this particular use case (receive XML, store XML as BLOB in database), I would recommend not using JAXB at all. Are you able to change your web service client to recieve the data as XML instead of POJOs?

If you want/need to receive the data as POJOs then assuming you are using the default UTF 8 encoding it is noticably faster to write to a byte[] using ByteArrayOutputStream than to write to a String using StringWriter (atleast it is for EclipseLink JAXB).

-Blaise

Thu, 17 June 2010 07:41

Eclipse User

Hello Blaise,

thanks for your advices. If possible (also from a requirements point of view), I will try to avoid using JAXB at the CXF interface. Anyway, I will persist the entire message as a byte[] as you suggested.

regards,
marco

Previous Topic:	PluralAttribute.getJavaType returns element type instead of collection type
Next Topic:	Readonly ManyToMany mapping?

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 10:19:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter