Lesson 10: Issuing push requests

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up the consolidated database.

For server-initiated synchronization, you can issue push requests by populating the PushRequest table directly, or making a change in the Dealer table. In the latter case, the Notifier begin_poll script detects the change in the Dealer table and populate the PushRequest table.

In either case, the PushRequest table supplies rows to the Notifier request_cursor script, which determines how remote devices receive messages.

 Insert a push request directly into the PushRequest table prompting server-initiated synchronization

  1. Connect to your consolidated database in Interactive SQL if you are not already connected.

    Run the following command:

    dbisql -c "dsn=sis_cons"

  2. Execute the following SQL statements:

    INSERT INTO PushRequest(mluser, subject, content)
    VALUES ('sis_user1', 'sync', 'not used');
COMMIT;

  3. Wait a few seconds for the synchronization to occur.

    When populated, the PushRequest table supplies rows to the Notifier's request_cursor script. The request_cursor script determines what information is sent in the message, and which remote devices receive the information.

  4. Execute the following SQL statements to make a change in the consolidated database Dealer prompting server-initiated synchronization:

    UPDATE Dealer
    SET RATING = 'B' WHERE name = 'Geo'; 
COMMIT;

  5. Wait a few seconds for the synchronization to occur.

    In this case, the Notifier begin_poll script detects changes in the dealer table and populates the PushRequest table appropriately. As before, once the PushRequest table is populated, the Notifier request_cursor script determines what information is sent in the message, and which remote devices receive the information.

  6. Proceed to Cleaning up.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1