0 Replies Latest reply on May 16, 2002 7:59 PM by new2jboss

    findByTimestamp problem in jaws.xml

    new2jboss

      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.