In JBoss-2.4.4_Tomcat-3.2.3, i've been trying to retrieve records based on timestamps with a method findByTimeStamp(java.sql.Timestamp);
The following findByTimeStamp always returns null in PostqresQL:
findByTimeStamp
where VWTIMESTAMP = {0}
<read-ahead>false</read-ahead>
and the sql script creating object was the following:
<cmp-field>
<field-name>timeStamp</field-name>
<column-name>VWTIMESTAMP</column-name>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</cmp-field>
Is it possible to find records based on timestamp or do they have be converted to dates? How can this be done correctly?
Thanks.