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

[ldimaggio]

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...

[maeste]

Which version of ESB are you using?
There was a bug in 3.3 solved here
https://jira.jboss.org/jira/browse/JBESB-1770

hoping it could help

[karypid]

Also, do you observe this behavior in the quickstart example or in your own code? If you are not using the quickstart, what is the type of the timestamp column in your table? It must be a VARCHAR field (i.e. a String) and not a TIMESTAMP.