18 - Run the Application

1. Start the ULLDemo1 application on the Palm V. It will display SQL SELECT failed because the local database is empty.

   
   
   

2. Leave the application running on the Palm V, and press the HotSync button to perform the first database synchronization.

   The application will display SQL UPDATE failed for one second before the HotSync operation starts. The update failed because the local database is empty.

   
   
   

3. After the one second delay, HotSync starts running and the Adaptive Server Anywhere conduit is executed.

   
   
   

4. When HotSync finishes you can tap the Log button to see how the conduit fared.

   
   
   

5. When you start ULLDemo1 again on the Palm V it will display hello, world because the local database now contains data.

   
   
   

6. On the Palm V, change hello, world to something else, like goodbye.
   
   
7. Press the HotSync button to perform the second database synchronization.

   The application will display SQL UPDATE OK for one second before the HotSync operation starts. The update works this time because the row to be updated now exists on the local database.
   
   

8. Back on the desktop PC, run dbisql.exe to confirm the synchronization worked.

   
   
   

9. Here is the conduit trace file c:\Palm\CarterB\ulldemo1_dbhsync.log:
   
   

   I. 10/21 21:36:21. Log file: C:\Palm\CarterB\ulldemo1\ulldemo1 _dbhsync.log I. 10/21 21:36:21. Verbose logging: show row values I. 10/21 21:36:21. Verbose logging: show script names when invoked I. 10/21 21:36:21. Verbose logging: show script contents when invoked I. 10/21 21:36:21. Verbose logging: show translated SQL for prepared statements I. 10/21 21:36:21. Synchronization Server started I. 10/21 21:36:21. Sybase Adaptive Server Anywhere MobiLink Version 6.0.3.2904 Debug I. 10/21 21:36:22. ODBC DBMS Name: Adaptive Server Anywhere I. 10/21 21:36:22. ODBC DBMS Version: 06.00.0000 I. 10/21 21:36:22. ODBC DBMS Driver Version: 06.00.0003 I. 10/21 21:36:22. ODBC Version supported by the driver: 3.51 I. 10/21 21:36:22. Translated SQL: SET OPTION PUBLIC.MAX_CURSOR_COUNT = 0 I. 10/21 21:36:22. Translated SQL: SET OPTION PUBLIC.MAX_STATEMENT_COUNT = 0 I. 10/21 21:36:22. ODBC isolation set to: Read Committed I. 10/21 21:36:22. Connected I. 10/21 21:36:22. : Translated SQL: SET OPTION PUBLIC.MAX_CURSOR_COUNT = 0 I. 10/21 21:36:22. : Translated SQL: SET OPTION PUBLIC.MAX_STATEMENT_COUNT = 0 I. 10/21 21:36:22. : ODBC isolation set to: Read Committed I. 10/21 21:36:22. : Connected to consolidated database I. 10/21 21:36:22. : Translated SQL: SELECT script_id FROM ul_connection_script WHERE event = ? I. 10/21 21:36:22. : begin_connection (undefined) I. 10/21 21:36:22. : COMMIT I. 10/21 21:36:22. : Translated SQL: SELECT user_id FROM ul_user WHERE name = ? I. 10/21 21:36:22. : Synchronization request from: ULLDemo1 I. 10/21 21:36:22. [ULLDemo1]: Translated SQL: SELECT last_modified FROM ul_scripts_modified I. 10/21 21:36:22. [ULLDemo1]: ul_scripts_modified last modified at: 1999-10-21 10:01:24.890000 I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: SELECT table_id FROM ul_table WHERE name = ? I. 10/21 21:36:23. [ULLDemo1]: begin_synchronization (undefined) I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: SELECT script_id FROM ul_table_script WHERE table_id = ? AND event = ? I. 10/21 21:36:23. [ULLDemo1]: begin_synchronization ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: UPDATE ul_user SET commit_state = ? WHERE name = ? I. 10/21 21:36:23. [ULLDemo1]: COMMIT I. 10/21 21:36:23. [ULLDemo1]: begin_upload (undefined) I. 10/21 21:36:23. [ULLDemo1]: begin_upload ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: begin_upload_rows ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: SELECT script FROM ul_script WHERE script_id = ? I. 10/21 21:36:23. [ULLDemo1]: Updated row (new values): I. 10/21 21:36:23. [ULLDemo1]: 1 I. 10/21 21:36:23. [ULLDemo1]: hello world I. 10/21 21:36:23. [ULLDemo1]: upload_cursor ULLDemo1 (open for read and write): SELECT id, hello FROM ULLDemo1 WHERE id = ? I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: SELECT id, hello FROM ULLDemo1 WHERE id = ? I. 10/21 21:36:23. [ULLDemo1]: upload_cursor ULLDemo1 (close) I. 10/21 21:36:23. [ULLDemo1]: end_upload_rows ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_upload ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_upload (undefined) I. 10/21 21:36:23. [ULLDemo1]: COMMIT I. 10/21 21:36:23. [ULLDemo1]: begin_download (undefined) I. 10/21 21:36:23. [ULLDemo1]: begin_download ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: begin_download_deletes ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_download_deletes ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: begin_download_rows ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: download_cursor ULLDemo1 (open for read): SELECT id, hello FROM ULLDemo1 I. 10/21 21:36:23. [ULLDemo1]: Translated SQL: SELECT id, hello FROM ULLDemo1 I. 10/21 21:36:23. [ULLDemo1]: Insert/Update row: I. 10/21 21:36:23. [ULLDemo1]: 1 I. 10/21 21:36:23. [ULLDemo1]: hello world I. 10/21 21:36:23. [ULLDemo1]: Ignoring redundant row I. 10/21 21:36:23. [ULLDemo1]: download_cursor ULLDemo1 (close) I. 10/21 21:36:23. [ULLDemo1]: end_download_rows ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_download ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_download (undefined) I. 10/21 21:36:23. [ULLDemo1]: COMMIT I. 10/21 21:36:23. [ULLDemo1]: end_synchronization ULLDemo1 (undefined) I. 10/21 21:36:23. [ULLDemo1]: end_synchronization (undefined) I. 10/21 21:36:23. [ULLDemo1]: COMMIT I. 10/21 21:36:23. [ULLDemo1]: Synchronization complete I. 10/21 21:36:23. : end_connection (undefined) I. 10/21 21:36:23. : COMMIT I. 10/21 21:36:23. : Disconnected from consolidated database I. 10/21 21:36:23. : Disconnected I. 10/21 21:36:23. : Synchronization Server finished