[esb-issues] [JBoss JIRA] Commented: (JBESB-2212) sql-message-filter optional attribute "insert-timestamp-column" actually not optional

sql-message-filter optional attribute "insert-timestamp-column" actually not optional ------------------------------------------------------------------------------------- Key: JBESB-2212 URL: https://jira.jboss.org/jira/browse/JBESB-2212 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Transports Affects Versions: 4.2.1 CP4 Reporter: Lukas Petrovicky Assignee: Mark Little Fix For: 4.2.1 CP5 XSD for jboss-esb.xml clearly states that the parameter "insert-timestamp-column" for sql-message-filter is optional. However, when you don't supply it, following queries are executed, which causes the whole SQL provider not to work correctly (notice the missing column name): update NOTIFICATIONS_TABLE set STATUS_COL = 'W' , = 'Tue Dec 02 10:17:23 CET 2008' where STATUS_COL = 'P' and UNIQUE_ID = 1234 This is what I have in the jboss-esb.xml: <sql-message-filter tablename="NOTIFICATIONS_TABLE" status-column="STATUS_COL" message-id-column="UNIQUE_ID" message-column="MESSAGECONTENTS" /> This was discovered on SOA-P 4.2.0 CP03 by one of our regression tests - it is clearly a regression as it worked fine on SOA-P 4.2.0 CP02.