Hi All,

I have a table with 4 columns. the 4th column contain XML file.

that xml file contain 3 fields.

I need to display 3+3 columns to the user.

so how to retrieve value from XML file and how to map those fields??

please provide some information.


thanks in advance
Gopal

Our product has a similar problem, and here is what we did:

1. Added real columns for data that comes from the XML, in addition to the BLOB for storing the XML itself
2. Gave each additional column a public getter and a private setter, use access="property"
3. Mapped the XML property with access="field"
4. Added a getter and a setter for the XML property, and parsed the XML in the setter. Then we called the private setters of the fields we added in step 1with the values that came from parsing the XML.

Good luck!
------------------

Don't forget to rate.

do you have a sample code so that will be helpful for me.

HI i got this , i used Hibernate createSQLQuery()

and there is a method called extractValue() i used this method to extract value from xml file.