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.
