Hi

I am using hibernate to retrieve data from a db2 database on a mainframe. The problem I have is with the System key. The System Key when retrieved from the database is not readable with square boxes for character I think java does not recognize. But when I query using this system (e.g. where systemKey =) I get the right data I want back. This is fine as I don’t need the System Key to display, only to query or as a foreign key. The question I am asking is will Java or Hibernate ever try to change the retrieve value of System Key (the character it does not recognize) special when the System Key is first retrieved.

My second question is that I can retrieve the hexadecimal value of the System Key by using the query e.g. select HEX(c.customerId). But I can’t retrieve data in the where clause using a HEX value, as in db2, you would normally use X, e.g. from Customer as c where c.customerId= X'F1F0F0F0F0F0F0F1'. This does not seem to work in Hibernate, so can someone please tell me how to change the hexadecimal value to a System Key in a query in hibernate.

Thanks Pritesh

Your second question can maybe be solved by registering a custom SQLFunction with Hibernate. To do this you need to access the Configuration object when your application is starting. Something like this may work, but I don't know the corresponding Type for the SystemKey.



After this you should be able to do: