Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Adapter Notifications | Before Configuring or Managing Notifications
 
Before Configuring or Managing Notifications
Perform the following steps before configuring or managing notifications.
*To prepare to configure or manage Adapter for JDBC notifications
1. Start your Integration Server and Integration Server Administrator, if they are not already running.
2. Make sure you have Integration Server Administrator privileges so that you can access Adapter for JDBC's administrative screens. For information about setting user privileges, see the webMethods Integration Server Administrator’s Guide for your release.
3. Be sure to check for a list of known limitations for your database driver since it may affect how you configure your connections and notifications.
4. If you have made changes to the table schema for a given adapter notification, be sure to update the adapter notification accordingly.
5. If you plan to use the Only Once notification feature, for details, see Using the Exactly Once Notification Feature.
6. Using Integration Server Administrator, make sure the WmJDBCAdapter package is enabled. For instructions, see Enabling Packages.
7. Using Integration Server Administrator, configure an adapter connection to use with the notification. For instructions, see Configuring Adapter for JDBC Connections.
Note:
Integration Server provides a built-in service you can use at design time to change the connection associated with a polling notification. For more information, see Changing the Connection Associated with an Adapter Service or Notification at Design Time.
8. Start Software AG Designer if it is not already running.
9. Using Designer, create a user-defined package to contain the notification, if you have not already done so. When you configure notifications, you should always define them in user-defined packages rather than in the WmJDBCAdapter package. For more information about managing packages for the adapter, see Overview of Package Management.
10. You must schedule a notification and then enable it before you can use the notification. For instructions, see Managing Polling Notifications.
11. If you want to enable the same polling notification on multiple Integration Server instances connecting to the same source database to achieve automated failover, you have to use the polling notification within an Integration Server cluster. For information how to configure clustered polling notifications, see Polling Notification Support in Integration Server Clusters.