Salesforce

Local Databases (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Local Databases (Magic xpa 2.x)

Local databases can be used to store and access data locally on RIA clients. Using this database, you can define local data sources, which let you save data on the client and use it later on, mainly in Offline programs that do not access the server.

Using local storage can also improve performance by locally caching data.

The following is information about working with the local database:

Direct SQL

A Local database cannot be used in a Direct SQL statement.

Transactions

The transaction for local data sources behaves as a physical transaction. All the tasks that include a local data source will be in the same transaction. (This is planned to be changed in future versions.)

Commit

Commit of the local data is done according to the task that opened the transaction. If a transaction is also opened in sibling tasks, then the data of these tasks will also be committed. (This is planned to be changed in future versions.)

Roll back

Rolling back a task that has a local data source will roll back:

  • All the tasks that have a local data source. (This is planned to be changed in future versions.)

  • The deferred transaction of a parent task.

Related Topics

Since version:

2.4

Reference
Attachment 
Attachment