QAnywhere client applications can now use an UltraLite database as the client message store. This provides a lighter-weight solution for pure messaging applications on mobile devices. A pure messaging application means an application that uses store and forward messaging, but not data synchronization.

Some of the key advantages of UltraLite are:

• It has a smaller application footprint and does not require full SQL Anywhere installation.
• It has a smaller process footprint. QAnywhere Agent requires only 3 processes instead of 4 (uleng12, dblsn, and qauagent instead of dbeng12, dbmlsync, dblsn, and qaagent).

Keep in mind the following limitations of UltraLite when deciding between SQL Anywhere and UltraLite:

• There is no support for "ESCAPE" keyword in transmission rule condition syntax.
• There is limited support for property attributes. You can only use property attribute functionality with the predefined property ias_Network. See Custom client message store properties.

UltraLite should always be used rather than SQL Anywhere when SQL Anywhere is not already installed. SQL Anywhere is available for circumstances where you want to add messaging along side an already implemented SQL Anywhere data synchronization solution. However, UltraLite is recommended in all pure messaging environments.

From an application perspective, the client API remains the same for UltraLite as for SQL Anywhere with the following exception: the QAManager configuration properties should include the setting DATABASE_TYPE=UltraLite for UltraLite message stores. If the property DATABASE_TYPE is not set, the default is SQLAnywhere.

The client APIs supported for UltraLite are C# (for Microsoft .NET) and Java. For UltraLite, the C++ and SQL APIs are not supported.

The other difference from an application perspective is that the QAnywhere Agent for UltraLite is qauagent.exe. The QAnywhere Agent for UltraLite supports many of the same options as the QAnywhere Agent, with the following exceptions:

• -sv is not applicable to UltraLite
• -pc[+|-] is not supported by qauagent
• -sur is not applicable to UltraLite
• -c connection parameters are restricted to those documented in UltraLite connection parameters

In general, transmission rules are fully supported by the QAnywhere Agent for UltraLite. The one limitation is the support for Property attributes. Transmission rules can only use the following attributes of the predefined property ias_Network:

• ias_Network.Cost
• ias_Network.CommunicationAddress
• ias_Network.CommunicationType

 See also