Creating transaction-to-cache mappings in the IDE

After the database cache is created, for each transaction object that already exists in the application, map it with the cache in the transaction-to-cache mappings section. The mapping will be deployed to the PowerServer, and then be used to set up static database connection for the app runtime. Note that you only need to map the transaction objects that already exist in the PowerBuilder application.

To configure the mapping of the transaction object with the cache:

  1. Go to the PowerServer project painter > Database page > Advanced tab.

  2. In the Transaction-to-cache mappings section, input the transaction object name (for example "sqlca") and then select one of the configured caches to map with.