I'd like to get all Objects that have a Calendar/Date-Element which is older then the actual time.
I'm using the following line right now:

this.getSession().delete("from MyElt where OBJTIME < now");


the mapping is:
...
<property name="objTime" column="OBJTIME" type="calendar"/>
...


My call works fine with my hsql database, because it knows about the "now"-String and replaces it with the current date.

Is there a way to make my this.getSession().delete(...)-String independent from the database-type?

Well, my problem is that I think, that the expression "now" won't work because this is just a special keyword in hsql...
Isn't there a way to compare the times without using "now"?

Ummm. Do you realize that I write most of Hibernate?

I have a pretty fair idea of what works.

I'm sorry. I did not want to doubt this. I just thought that the now-function was database-specific.

I'm sorry, this was obviously my fault.

Thanks for the help!

It is database specific. If you need to abstract SQL functions from multiple databases, you need to use hibernate.query.substitutions. We've discussed in the dev list that it is kinda impractical to try to abstract all SQL functions (though in future we might go for an abstraction layer for just the ANSI standard functions like current_date).