Hi All,

How does hibernate handles null values.

I am searching some entity using some values, at runtime of these values may be null. In this situation how does hinbernate handles null values. for example I am searching for person details with his emp ID but emp ID value is null .

Thanks,

I suggest looking at the SQL that H generates and uses to perform your search and I think you will know exactly what will happen in case of nulls.

Usually if the passed paramter is of object type and if that object is null then it will throw SQL exception saying- required [type], found binary.

If you try to access properties of a null object in HQL than I would say it is expected reaction.
Unfortunately in the named queries H does not have conditional blocks like iBatis therefore you need to make sure that all the used objects are not null ...