Hi,
I am using collection mapping and I am adding SQL conditions in the "where" on the current date like this :
<set name="activeQuotas" inverse="true" lazy="false" cascade="all" where="current_date &gt;= start_date">

I get an Exception when the collection is fetched because Hibernate produces the following SQL for the "where" condition :
activequot0_.current_date >= activequot0_.start_date

When I use SYSDATE instead, it works fine but I am using current_date because it's more portable. (see http://forum.hibernate.org/viewtopic.php?t=933792&highlight=)

Is it a bug or I have to configure something ?



Hibernate version:2.1.6

Name and version of the database you are using:Oracle 9i