1 Reply Latest reply on Aug 29, 2009 11:23 AM by Tom Cunningham

    SQL Notifier - sequence of columns changes?

    Len DiMaggio Apprentice

      Can anyone shed any light on this? I'm seeing an intermittent situation where the order in which the SQL table columns in the message generated by the NotifySQLTable notifier is inconsistent. I have not, however, been able to see any pattern (ESB release or DB used).

      With this notification table definition:

      UNIQUE_ID integer, STATUS_COL varchar(255), MESSAGECONTENTS varchar(1024), COLUMN1 varchar(255)

      And this notifier definition:
       <action class="org.jboss.soa.esb.actions.Notifier" name="SQLNotificationTest">
       <property name="okMethod" value="notifyOK"/>
       <property name="notification-details">
       <NotificationList type="OK">
       <target class="NotifySqlTable" connection-url="jdbc:mysql://localhost:3306/soaman"
       dataColumn="MESSAGECONTENTS" driver-class="com.mysql.jdbc.Driver"
       password="soaman" table="NOTIFICATIONS_TABLE" user-name="testing">
       <column name="STATUS_COL" value="P"/>
       <column name="COLUMN1" value="abc"/>
       <column name="UNIQUE_ID" value="1234"/>

      I'm sometimes seeing a message that contains:
      {UNIQUE_ID=1234, COLUMN1=abc, MESSAGECONTENTS=the message}

      And sometimes:
      {UNIQUE_ID=1234, MESSAGECONTENTS=the message, COLUMN1=abc}

      It's not a big deal - but it is puzzling...thx!