Hi everybody.

I have a problem which I hope I could get some help for.

I have a hql query where I want customer back for a certain customerId, where the customerId is a system key (hex value).
e.g.

("from Customer as c where c.customerId=HEX('F1F0F0F0F0F0F0F1')");

The problem I am having is that hibernate is converting the hex value first into unicode, which I don't want before it sends it to the database.

I am using a db2 on the mainframe and I want the whole query to be sent as it is with the same hex values.

Can I get some help please.

Thanks Pritesh