Hi,

we are working on a content management system and we have to presist XML data into Oracle XML DB which would contain tables having XMLTYPE data. I would like to know the following

1) Does 3.2 version of Hibernate supports this feature out of the box.

2) Do we have to implement our own custom persister class for this.

3) Does using Usertype solves the problem with retrieval.

If anyone has worked on this, i would appreciate if he/she can share his views.

Rishi

Any takers for this ...!!!! can the experts pour in thier opinion .

Hi Rishi,



nope! :(



Yuo "only" need to write your own UserType which implements UserType, Serializable. You will find some implementation of this usertype in the forums.



What problem? No problems if you correctly implement your usertype! ;)



Done ;)
Adding support for XMLType in hibernate is quite straightforward, but you will incur some problems when reverse-engineering: I still have some mapping issues!
Hope I cleared out some doubt!!
Xserty

Hi,

As per my understanding implementing the UserType interface is only meant to take care of the Serialization of the w3C DOM type which oracle returns to a generic type on which you can invoke XMLTYPE methods.

What about the follwowing .

1) How do we take care of mapping of Class to the XMLTYPE table.

2) Can we invoke the methods of the HibernateTemplate (i.e save ) OR we have to make use of JAVA DOM API for XMLType .

regards
Rishi