Hi all,

I'm new to hibernate and I'm having trouble with a many-to-one mapping. Our database contains a mixture of null values and single spaces which represent a null. Unfortunately this is something that we can not change. When we run our query Hibernate finds a single space and attempts to find this value as a primary key in the other table and obviously can't find this result. What would be ideal is a method of telling Hibernate that a ' ' in the table represents a null. We have looked at using filters and custom selectors but can't see how this would work.

I looked through the faq and the tutorials and couldn't find a solution. If i have missed the solution somewhere in the documentation please post a link and i will close this topic.

Thanks,
A