UltraLiteJ supports databases in memory (non-persistent) and in device storage (persistent), including the BlackBerry store (internal flash) and SD cards.

Transactions are the set of operations between commits or rollbacks. For persistent database stores, a commit makes permanent any changes since the last commit or rollback. A rollback returns the database to the state it was in when the last commit was invoked.

Each transaction and row-level operation in UltraLiteJ is atomic. An insert involving multiple columns either inserts data to all the columns or to none of the columns.

UltraLiteJ uses isolation level zero (read uncommitted) to provide the maximum level of concurrency.

Persistent stores are page based; UltraLiteJ operates on pages in cache. A working set of pages is maintained in cache and is managed using a first-in, first-out (FIFO) scheme. Pages that are currently in use are locked in cache to avoid being swapped out.

You can configure the size of the UltraLiteJ cache.

UltraLiteJ can use the lazy loading of indexes and row pages to improve the startup of a persistent database. Indexes and row pages are only loaded when first accessed by an application.

For small databases, UltraLiteJ keeps copies of all row and index pages in memory.

For larger databases, the database can be configured each time it is opened to limit the number of rows and index pages that resident in memory at one time.

Encryption is set using the setEncryption method of a Configuration object, which takes an EncryptionControl to encrypt and decrypt pages. You must supply your own encryption control.

As a MobiLink synchronization client, UltraLiteJ has a built-in transaction log-based change tracking system so that database changes can be synchronized.

Data synchronization can be performed using HTTP or HTTPS network protocols. HTTPS synchronization provides secure encryption to the MobiLink server.

UltraLiteJ provides a publication model that lets you synchronize selected tables and selected rows from those tables from your database to make efficient use of network resources.

UltraLiteJ uses Unicode (encoded as UTF-8 in the database). The collation is the default sort order for Java and is equivalent to the UTF8BIN collation supported by SQL Anywhere. During synchronization with a MobiLink server, UltraLiteJ notifies MobiLink that it uses the UTF8 character set and collation.

Blackberry internal flash and SD cards are supported by UltraLiteJ.