Red Hat Training

A Red Hat training course is available for JBoss Enterprise SOA Platform

13.8.5. NotifySqlTable

Class NotifySqlTable
Purpose Performs a notification by inserting a record into an existing database table. The database record contains the ESB message contents and, optionally, other values specified using nested <column> elements.
Attributes
  • driver-class
  • connection-url
  • user-name
  • password
  • table - table in which notification record is stored.
  • dataColumn - name of table column in which ESB message contents are stored.
Child column
Child Attributes
  • name – name of table column in which to store additional value
  • value – value to be stored
<target class="NotifySqlTable" driver-class="com.mysql.jdbc.Driver"
connection-url="jdbc:mysql://localhost/db"
user-name="user"
password="password"
table="table"
dataColumn="messageData">
<column name="aColumnlName" value="aColumnValue"/>
</target>