Lesson 7: Issue push requests

In this lesson, you make a change to the Dealer table in the consolidated database so that the information can be downloaded into the remote database when the MobiLink Listener polls for push notifications. You then prompt a server-initiated synchronization by inserting a poll key value into the consolidated database. The Notifier runs the request_cursor event, detects the poll key in the non_sync_request table, then sends a push notification to the MobiLink Listener. When the MobiLink Listener receives the push notification, it synchronizes with the MobiLink database and updates the remote database.

To make a change in the consolidated database

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

Run the following command:
dbisql -c "dsn=SIS_CarDealer_LP_DBLSN_CONDB"

Run the following SQL script:

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

You issue push requests by populating the non_sync_request table directly. The poll key column determines which device should receive push notifications.

To prompt server-initiated synchronization

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

Run the following command:
dbisql -c "dsn=SIS_CarDealer_LP_DBLSN_CONDB"

Type the following script:

INSERT INTO non_sync_request(poll_key) VALUES ('%remote_id%.no_action');
COMMIT;

Wait a few seconds for the synchronization to occur.

The MobiLink Listener should poll the consolidated database, download the push notification, then update the Dealer table on the remote database.

To stop server-initiated synchronization with a device, delete the poll key value from the non_sync_request table.

To stop server-initiated synchronization

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

Run the following command:
dbisql -c "dsn=SIS_CarDealer_LP_DBLSN_CONDB"

Type the following script:

DELETE FROM non_sync_request WHERE poll_key = '%remote_id%.no_action';
COMMIT;