Hello.
I am using Hibernate 3.1

I am trying to do a condition based join on a 1-many relationship. I want to make a join with a record on the many side that has a date column to be null.I am able to join if I have condition with a specific date, but however I give the syntax, hibernate is not accepting the 'date is null' condition.

here is what I am using

<many-to-one name="maxBidder" property-ref="maxBidder">
<column name="itemkey"></column>
<!-- <formula>'2007-07-02 00:00:00.000000000'</formula> -->
<formula>('is null')</formula>
</many-to-one>

The concrete date one works, but not the 'is null' one. I tried with different type of quotes etc.

Any help on this syntax is greatly appreciated and I will rate for sure!

R