Date of First Response: 2008-10-30 08:16:13
project_key: SOA

I'm seeing an odd warning message (see below) if the message-id-column from an SQL notifier is inadvertently omitted from a corresponding SqlTableGatewayListener.

  If I setup a listener with these settings:

<sql-bus busid="notifiedSQLChannel">
   <sql-message-filter tablename="NOTIFICATIONS_TABLE"
       status-column="STATUS_COL"
       message-id-column="UNIQUE_ID"
       message-column="MESSAGECONTENTS"
       insert-timestamp-column="FAKE_TS_COLUMN" />
</sql-bus>

  And then setup a notifier, with these settings, but omit the message-id-column:

<action name="SQLNotificationTest"
   class="org.jboss.soa.esb.actions.Notifier">
   <property name="okMethod" value="notifyOK" />
   <property name="notification-details">
       <NotificationList type="OK">
           <target class="NotifySqlTable"
               driver-class="@DB_DRIVER@" connection-url="@DB_URL@"
               user-name="@DB_USERNAME@" password="@DB_PASSWORD@"
               table="NOTIFICATIONS_TABLE" dataColumn="MESSAGECONTENTS">
               <column name="STATUS_COL" value="P" />
               <column name="UNIQUE_ID" value="1234" />      ------> If this is omitted,
           </target>                                                the warning listed below is logged
       </NotificationList>
   </property>
</action>

This warning is logged:

22:01:36,965 WARN  [SqlTableGatewayListener] Cannot change row state from Pending to Working.  Number of rows in state Pending = 0
22:01:47,052 WARN  [SqlTableGatewayListener] Cannot change row state from Pending to Working.  Number of rows in state Pending = 0
22:01:57,055 WARN  [SqlTableGatewayListener] Cannot change row state from Pending to Working.  Number of rows in state Pending = 0
22:02:07,059 WARN  [SqlTableGatewayListener] Cannot change row state from Pending to Working.  Number of rows in state Pending = 0
22:02:17,063 WARN  [SqlTableGatewayListener] Cannot change row state from Pending to Working.  Number of rows in state Pending = 0

  It's a broken configuration - but a pretty confusing error message. 

See attached standalone test - modified version of CP02 notification Quickstart.