What is the best way to save instant data into DB?

I am new to xforms, but playing with OPS with liferay. I could produce a simple xforms with data stored in instance xml file. Now I wonder what is the best way to save these data into DB. I use JSF with hibernate for DB opration on liferay, but don't know how to handle xforms data.

I could not find any tutorial about saving xml data into DB.

thanks

Fran555 wrote

I am new to xforms, but playing with OPS with liferay. I could produce a simple xforms with data stored in instance xml file. Now I wonder what is the best way to save these data into DB. I use JSF with hibernate for DB opration on liferay, but don't know how to handle xforms data.

I could not find any tutorial about saving xml data into DB.

If you can, the best way is to store the XML as-is in the database. This avoid translating the data back and forth into another format (i.e. relational format). If you really need to store the data in a relational database, you have many options:

* Use some mechanism provided by the database. For instance on Oracle you can store the XML as-is using the XMLType, and create an view based on the stored XMLType "objects" stored in the database.
* Use the SQL processor to shred the data (http://www.orbeon.com/ops/doc/processors-sql).
* POST the data to a service implemented in your language of choice that stored that stored in the database using your library of choice (say servlet using Hibernate).

Alex