Skip Headers
Oracle® Database Lite Developer's Guide
10g (10.0.0)
Part No. B13788-01
  Go To Table Of Contents
Go To Index


9 Using Mobile Sync for Palm

This document discusses using Mobile Sync (mSync) for Palm. mSync for PalmOS allows a user or a developer to synchronize data with the Mobile Server. User can run the application (which can be found in Oracle Database Lite program group) manually and configure various settings. He or she can then tap the Sync button to manually initiate synchronization over the default network connection configured on the PDA. There are several other ways to invoke sync with pre-configured settings:

9.1 Configuring mSync

When mSync is run, it displays a screen with the most commonly used synchronization settings. Table 9-1 shows the controls for the synchronization settings that are displayed by mSync.

Table 9-1 List of Controls for Synchronization Settings

Option Use
User Name Case-insensitive user name on the mobile server
Password Case-insensitive password on the mobile server
Change (password) If selected, New and Confirm fields are shown. Enter the new password twice to guard against typing mistakes. On the next successful sync, mobile server password will be changed
Save password Tap this checkbox to save the password on the PalmOS PDA. You will not have to reenter password every time you sync, however anyone with physical access to your Palm will be able to sync, and possibly discover your password. This option is required to use HotSync and automatic sync through SODA or SODA Forms applications.
Server Enter host name or hostname:port of your mobile server. When syncing over network, you might consider entering the IP address instead to work around DNS configuration problems.
Proxy When this checkbox is active, an additional Proxy field appears on screen. Enter the hostname or hostname:port of your HTTP proxy server. This option only applies during HTTP sync. To configure a proxy server for HotSync, check Internet Explorer settings on your desktop.
Secure This checkbox activates secure sync over HTTPS rather than plain HTTP. You need a PalmOS 5.2 or later PDA to do a secure network sync. However, any device can HotSync using this option. HTTPS sync normally requires a valid certificate to be purchased and installed on the mobile server. For development purposes, you may prepend @! to server's hostname to test without a valid certificate. This option should never be suggested to end users, as it undermines the security provided by HTTPS.
Forced Tap this checkbox to do a complete refresh on the next sync. This can solve some data consistency problems. Note that this option is automatically cleared after one sync.
Log button Tap this button to launch LiteLog application. You will be able to see the log of the recent failed and successful sync attempts, as well as any crashes or critical errors encountered by Oracle Database Lite applications.
Sync button This button will start a sync over the default network connection.
Cancel button This button will exit mSync and re-start the SODA or SODA Forms application, if any, that initiated it.

mSync also provides the synchronization settings item under its Options menu, which can be used to adjust some less frequently used settings, as described in Table 9-2.

Table 9-2 Synchronization Settings in the Options Menu

Option Use
Hangup after sync Hangup the network connection immediately after the sync is done. Normally, the connection will be left on and disconnected when the timeout configured in the Network settings panel expires.
Push only Send locally made changes to the server, but don't get any data back. This is a quick way to backup local data to the server.
Ignore apps Disable application deployment and auto-upgrade of the Oracle Database Lite runtime. Tap this checkbox to sync with a version of mobile server different from the client version without causing an upgrade.
Remote Hotsync Tap this checkbox when doing a Network hotsync to enable successful retries if the Palm Desktop times out.
NLS Code Enter an Oracle-supported language code to sync using the appropriate character set. Most Japanese, Chinese or Korean devices are automatically detected by Oracle Database Lite, but some third-party language add-ons are not.

9.2 Using HotSync to Synchronize Data with the Mobile Server

This section discusses using HotSync to synchronize data with the Mobile Server.

9.2.1 Configuring HotSync for a PalmOS Device

To synchronize Oracle Database Lite databases over HotSync, first install Mobile client for PalmOS on a PC that already has Palm Desktop. Start mSync on PDA and configure all the sync options, including "Save password" checkbox. Also, find and enable "Stay on in Cradle" options in PalmOS Prefs application. Now every HotSync will automatically synchronize Oracle Database Lite data with the Mobile Server. After HotSync finished, refer to LiteLog on the device or HotSync log on the desktop to check for errors.

9.2.2 HotSync Timeout Errors

If the mobile server sends a large volume of data to the PDA, Palm Desktop may timeout during HotSync and you will see a message box on the desktop while the PDA is still processing sync data. Just dismiss the dialog or let it time out automatically. mSync will detect this condition and automatically do another HotSync, which should go through successfully. Note that if you are viewing the HotSync log when the PDA reconnects and in some other conditions the retry may fail. Generally, the error can be ignored, except if another application registered a low priority conduit that is supposed to run after Oracle Database Lite. In this case, do another HotSync manually.

This timeout is an issue in Palm Desktop software rather than Oracle Database Lite, in particular SyncCallRemoteModule API that is used by a conduit to invoke an application on Palm. If the application takes a lot of time to run, Palm Desktop times out and aborts HotSync. If PalmSource provides a configurable timeout in a future release of Palm Desktop, the message box can be avoided by increasing it.

9.2.3 Configuring PalmOS Emulator for HotSync

It's possible to do a Network HotSync with the Palm emulator with the following steps:

  1. Enable Network in HotSync tray menu on the desktop running the Palm emulator.

  2. Check the "Remote HotSync" checkbox in mSync options menu.

  3. Make sure that "Redirect NetLib calls to Host TCP/IP option" is enabled.

  4. Run the HotSync application. Click the "Modem" (rather than "Local") push button.

  5. In Modem sync preferences, choose "Network" rather than "Direct to modem".

  6. In "Primary PC setup", enter "localhost" as the hostname and "" as the IP address.

  7. Click on the connection field below the HotSync icon and choose "AT&T WorldNet" or any other connection.

  8. Click on the HotSync icon in the middle of the screen to do a network HotSync.

9.3 Using Network Sync

mSync can also open a direct connection to the mobile server without going through the Palm Desktop. If you have a valid network connection, for example through a modem, integrated cellular phone or Bluetooth, just tap the Sync button on the mSync main screen.

9.3.1 Synchronizing Using a Cradle and Windows Desktop

It's possible to connect a PalmOS device to the network using a cradle connected to your PC rather than a dedicated modem. First, you need to enable Incoming Connections. Modern PalmOS devices use a USB cradle, that requires 3rd-party software to establish a network connection. One such product is Softick PPP, which can be purchased from Note that we don't offer support for any issues you may encounter with such 3rd-party software.

For serial cradles, follow the following steps:

Setting up the desktop

  1. Uncheck "Local Serial" option in the HotSync pop-up menu and leave it off while you are using the cradle for networking

  2. Go to Modem control panel and create a new modem of type "Communications cable between two computers". Set "Maximum port speed" to 56K and "Flow control" to Hardware.

  3. In Windows XP, open the Network control panel, choose "Create a new connection", then "Setup a new connection" and finally "Accept incoming connections". Choose the modem you just added in "Devices for Incoming Connections". Select at least one user in "Users you allow to connect". When you get to TCP/IP settings, choose "Allow callers to access my local area network".

  4. If your PC is not using DHCP, you need to find two sequential unused IP addresses on your local subnet and enter them in the fields under "Specify TCP/IP address.

  5. Older versions of Windows have different ways to enable incoming connections. For example, in Windows NT 4.0 the equivalent functionality is known as "Remote Access". You may need to adapt the instructions for the version running on your desktop.

Setting up the device

  1. Go to Connections panel in Palm preferences. Edit the "Cradle/Cable" connection details by setting speed to 56K and flow control to Hardware.

  2. In Network panel, create a new service. Enter username and password of the user you selected while setting up the desktop. Set the "Connection" to "Cradle/Cable".

  3. Choose Details/Script for your service. Enter the following script:

    Send: CLIENT

    Send: CLIENT


  4. Test the service by clicking Connect button. Once the connection is successful, choose Options/View Log from the Preferences menu. Type ping servername or ping serverip. If the ping succeeds, you should be able to sync with that mobile server by tapping the appropriate button in mSync.

9.3.2 Network Sync With PalmOS Emulator

To use mSync on the emulator, make sure "Redirect NetLib calls to Host TCP/IP" option is set in the preferences. To test SSL, run PalmOS simulator version 5.2 or later.