I wanted to use a WHERE clause in my <map>, cause I had, for the same kind of data, some limitations on the time.
For instance, I used to filter on the date and added this string:

<map ..... where="dataInizio<SYSDATE AND datafine>SYSDATE" >

but when Hibernate parse my WHERE SQL I can see that the Oracle SYSDATE is substituted with an alias of the class from where the map is loaded.
What can be wrong ? Is not SQL what I have to write into WHERE clause ?
Thank you for your help.
L.

Ok, no one helped me, so I solved my way.
I had to use a PL/SQL function, cause I think there is a bug in Template.renderWhereStringTemplate.
There the code check for an identifier without looking in the Dialect function table.
Doing so, the SYSDATE is always considered like an identifier, and "templated".
Do you think this behavious/checking can be added to this method ?
Ciao.

Can you post that to JIRA, please ?

Done.
Ciao.