Hi,

I would like to know if it is posible to map a column of type XML in oracle to a variable of type String.

In my table, I have a column of type XML that contains information in xml format and I am doing a select of that table through a HQL query (createQuery).
---> String HQL = "from TableName";
---> createQuery(HQL)

In order to map a column of type Varchar with a variable of type String I do the following in my hbm.xml file:
---> <property name="VariableName" column="ColumnName" length="100" type="string" not-null="true"/>

In this way, I am getting the varchar value from the column of the table to my string variable. What I need to do now is to get the column of type xml and map it as string in my string variable.
- Can I do this on hibernate?
- How should I map this in my hbm.xml file?

Thanks in advanced for your help.

Regards,
JeisonG