|Oracle® Database Lite SQLite Mobile Client Guide
Part Number E16214-01
The installation automatically sets the parameters in both the
POLITE.INI files, but you can modify them to customize the product behavior. To modify these files, use an ASCII text editor. You must have write permissions on the directory where either file is located to be able to modify them.
Note:On the WinCE and Blackberry platforms, these files are named with the extension of
.TXT, so that you can double-click on it to open the file.
The following describes the configuration files for the SQLite Mobile client:
OSE.INI file contains parameters that define the location of the SQLite database and SQLite Mobile client files, and how to customize synchronization for the SQLite database. There is a single
OSE.INI file for each mobile device for all users of that device. The latest modifications to parameters in the
OSE.INI file take effect only during a manual synchronization or after restarting the Sync Agent for automatic synchronization.
Depending on the platform, it can be located in one of the following directories on the mobile device:
On native clients, the
OSE.INI file is located in
\sqlite. On WinCE, this file is named
On Blackberry, the
OSE.TXT file is located in
On Android, the
OSE.INI file is located in
Applications import the
mSync.jar library; thus, the
<application_package> should be replaced with the user's application that invokes the
The following are the parameters for the
By default, the location of the SQLite database is determined by the
SQLITE.DATA_DIRECTORY parameter in the
OSE.INI file. However, if this parameter is not set, the location of the SQLite database on Win32, WinCE, or Linux platforms is determined by the location of the
The SQLite database, Oracle Database Lite repository files, and temporary synchronization data are stored in the
<user> directory, where
<user> is the synchronization user id. The database repository files are named with the
.db extension, such as
TERRY\mysqlite.db. These files are used to manage the change control for transactions and synchronization for the user.
Internal settings and parameters for the SQLite Mobile client is stored in the
Example for setting the directory on a Win32 platform:
Example for setting the directory on a Blackberry:
Queue-based: Both client and server changes are stored in a single queue. Whenever the snapshot is not locked by an application, the synchronization retrieves data from the In Queue and applies it to the base snapshot. At this point, the synchronization propagates data from the Out Queue to the server.
Although both snapshot types rely on triggers, queue-based snapshots allow concurrent operations on the SQLite database while any synchronization is in progress. The Sync Agent's compose operation places modified data into the Out Queue. Later, the Sync Session uploads multiple client transactions delineated by a unique transaction id to the server.
Set this type with
State-based. State-based snapshots decipher the difference in the state of the data between subsequent synchronization events. This snapshot type is more resource efficient than queue-based snapshots. Pure Java clients only support state-based snapshots. To enable queue-based snapshots, set the
SQLITE.QUEUES parameter in the
OSE.INI file to
POLITE.INI file centralizes database volume ID assignments, defines parameters for all databases on a system, and defines synchronization parameters. On the WinCE platform, the file name is
When you install SQLite Mobile client, the installation for Win32, WinCE and Linux platforms creates the
POLITE.INI file in the
Since the SQLite Mobile client configuration does not include the SQLite database, all sections except for the All Databases section applies on the SQLite Mobile client. Refer to Appendix E, "POLITE.INI Parameters" in the Oracle Database Lite Administration and Deployment Guide for details on these sections.