Example for Starting an Oracle Alerter

The following example shows how to execute the stored procedure on an Oracle database. In this example, a service of Publication Service with the TIBCO Rendezvous transport is configured with the alerter method selected. It is assumed that the rvpub.tra configuration has its data source name, user account name (demo) and password defined in the repository.

Prerequisites

The create_user.sql and alerter.sql statements are executed on the database server to initialize the database environment. For details, see "Post-Installation Tasks" in TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) Installation.

Procedure

  1. Start the adapter configuration by typing the following command:
    adbagent --propFile rvpub.tra
  2. Insert a message and then execute the commit_and_notify_table stored procedure with the publishing table monitored by the adapter.
    For example, if the adapter is monitoring the PUB_ORDER table, execute the stored procedure as follows: 
    sqlplus demo/demo
insert into ORDER_TABLE values(111,'Oak Table',499.95);
SQL> call commit_and_notify_table (’PUB_ORDER’);
    The procedure puts a message on Oracle AQ. The publisher endpoint then reads its publishing table and sends a message containing the changed data on its configured subject.

Result

This example shows how to notify an adapter configuration to poll a single table, that is, PUB_ORDER, for changes. You can use the commit_and_notify stored procedure to poll all publishing tables for changes.