Hi OJB users, I have a database table storing events combined with a timestamp, a deviceID specifying the device where the event occured and a unique ID. In some cases I have to know the latest event of a device that occured before a certain timestamp. At the moment I use QueryBySQL (see SQL statement below), but this statement contains the Oracle specific TO_DATE formatter. I'd rather use QueryByCriteria and define a Criteria object that can replace the SQL statement (May be I have to use a differnt RDBMS and don't want to change the source code). SQL statement as follows: select * from <tableName> where id = (select max(id) from (select * from <tableName> where timestamp = (select max(timestamp) from <tableName> where deviceid = '<deviceID>' and timestamp < TO_DATE('<day>.<month>.<year>.<hour>:<minute>:<second>', 'DD.MM.YYYY HH24.MI.SS'))))
Is there a way to define something like Criteria.addMin(...) or Criteria.addMax(...) that could be helpful? Is there a way to define nested queries like I use within the SQL statement? Thanks, Frank