Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Overview of the Adapter | Adapter Notifications | Ordered Notifications | Using Ordered Notifications
 
Using Ordered Notifications
Note:
You can create only one trigger for each operation on a table. For each notification, you can configure only one trigger for each table.
The following table lists the tasks required to use this notification:
For this task...
Use these tools...
1. Create an adapter connection. For details, see Overview of Adapter Connections.
Integration Server Administrator
2. Configure the notification and specify the:
*Adapter connection
*Source tables
*Type of operation associated with the Ordered Notification; that is, an insert, update, or delete operation
*Operation ID you create for each operation
*Output data fields to be published for each operation
*Database trigger and buffer table
The buffer table will hold the data selected by the trigger. The trigger will monitor the database table and insert data into the buffer table. For more details, see Ordered Notifications.
*Publishable document to contain the data from the buffer table. There is a single publishable document used for all events associated with the notification.
For more details about the Integration Server publishable documents, see the Publish-Subscribe Developer’s Guide for your release.
For instructions for configuring this type of notification, see Configuring OrderedNotifications.
Designer
3. If you plan to use an Integration Server flow or Java service, design it to react to the data changes contained in the notification's publishable document. Create the Integration Server trigger to use the notification's publishable document.
For details, see the webMethods Service Development Help for your release.
If you use a trigger, be sure to set the Processing mode option to Serial. For details, see Ordered Notifications.
Designer
4. Schedule and enable the adapter notification. When you enable the notification, it automatically creates the database trigger, sequence, and buffer table you configured when you created the notification. The Integration Server Scheduler invokes the notification periodically, based on the polling schedule parameters you created earlier, and continues to do so.
For instruction for scheduling and enabling notifications, see Managing Polling Notifications.
Integration Server Administrator
Designer and Integration Server Administrator