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 | Notification Types | Using Insert, Update, and Delete Notifications
 
Using Insert, Update, and Delete Notifications
The following table lists the tasks required to use these types of 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 table
*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.
*Output data fields contained in the publishable document
*Database trigger and buffer table
For instructions for configuring notifications, see Overview of Adapter Notifications.
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.
Designer
4. Schedule and enable the adapter notification. When you enable the notification:
*It automatically creates the database trigger and buffer table you configured when you created the notification.
*The Integration Server Scheduler invokes the notification and continues to do so periodically, based on the polling schedule parameters you created earlier.
For instructions for scheduling and enabling notifications, see Managing Polling Notifications.
Integration Server Administrator
Designer and Integration Server Administrator