Hi! Problem solved. I removed all the JDBC things and implemented two more finder methods for min and max of date such as:
<finder-method query="$rw_websiteID = $1 and rw_datetime in (select min (rw_datetime) from logfilerow where $rw_websiteID = $1)"> <method> <ejb-name>LogFileRow</ejb-name> <method-name>findByMinDateWebsite</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </method> </finder-method> Thanks. Marc.