Hi,
the following query

select listing from Instrument as instrument where instrument.duration not between :0 and :1

generates different results when using hsqldb 1.7.2 or Firebird 1.5 or Oracle because hsqldb counts also the null durations.
Is there a way to control the treatment of nulls through hibernate (e.g. by adding a 'and instrument.duration is not null' to the criteria)? I know this is more a db bug or feature, but should not hibernate transparently hide the db differences? ;)

Regards
Massimo

You have to do this manually.