Hi,

This question is for the arhitects of Hibernate. I've tried searching the forum and other search engines on how to integrate Hibernate and IBM's pureXml product. The system is not as hard if you use simple SQL statements on tables with xml data types from DB2 v9.

The problem arises when I use the new db2-fn which is typically followed by a colon ":" and the command you wish to do for an xquery statement. The dilema of course as you can see is that hibernate translates (in HQL) any text preceeded by the colon ":" as a parameter.

There were two ways for me to get around this but both of which I have a certain distaste for. The first method is to go to the lowest level of JDBC calls. But that totally defeats using Hibernate for such queries. The second way is to wrap my sql statements into stored procedures. But if I have an application that requires dynamic statements, that means building the logic into the stored procedure so that the statement becomes dynamic. It is a pain to code something like that on stored procedure and I would really prefer that programmed in my dao layer.

So, is there a way to get around the colon ":" problem. If not, are there any plans to support such a feature in Hibernate?

Thank you very much for your help or input on this problem.

what about showing the code you are trying to execute...