2 Replies Latest reply on Sep 9, 2008 6:32 AM by Alexandros Karypidis

    Question on the use of a timestamp DB table column in a list

    Len DiMaggio Apprentice

      I was wondering about the use of a timestamp column in an SQL listener or notifier.

      The ESB helloworld_sql_action quickstart includes the timestamp column:

      <sql-provider name="SQLprovider"
       url="jdbc:hsqldb:hsql://localhost:1704"
       driver="org.hsqldb.jdbcDriver"
       username="sa"
       password="">
       <sql-bus busid="helloSQLChannel" >
       <sql-message-filter
       tablename="GATEWAY_TABLE"
       status-column="STATUS_COL"
       order-by="DATA_COLUMN"
       where-condition="DATA_COLUMN like 'data%'"
       message-column="message"
       message-id-column="UNIQUE_ID"
       insert-timestamp-column="TIMESTAMP_COL"
       />
       </sql-bus>
      </sql-provider>
      


      But -I just noticed that I include the TIMESTAMP_COL in an SQL notifier - it writes a null value to the DB record. Is this expected? Thx...