Y la otra pregunta era sobre la database configuration

La misma transaction SQLCA  puede apuntar a dos caches diferentes o esto ya lo manejo en PowerServer's APIs desde Snap Develop ? para en tiempo de ejecucion cambiar de conexion a otra base de datos?

Best Regards,

Hi Milton,

Are you talking about an application session or DB transaction?  These are two different concepts.

There are 3 ways that an application session is released:

1. The user closes the PowerServer application.  Upon close, PowerServer will automatically release the session.
2. In the case of abnormal close or user leaves the application open, the session is released when the timeout period is reached.  You configure this session timeout in the Applications.json file.
3. You can programmatically access PowerServer's APIs and kill the session. You use the various SessionClient methods of the powerServerService class in the REST API.

There are 3 ways that an DB transaction is released:

1. Your application code executes a commit or rollback.
2. In the case of abnormal code execution, the transaction is released when the timeout period is reached.  You configure this transaction timeout in the Applications.json file.  Also, your database itself should have a timeout configuration as well.
3. You can programmatically access PowerServer's APIs and kill the transaction.  You use the various RollbackAndCreateTransactionAsync methods of the powerServerService class in the REST API.

Best regards,
Armeen

As I can see this is documented in the following link:
https://docs.appeon.com/pb2021/whats_new/How-to.html
It says:

The ServerAPIs project contains a number of configurable files under the AppConfig folder:

Hi.

Haven't tested yet, but in generated c# project's AppConfig folder there is a Applications.json file. It has the following contents:

{
  "Applications": [
    {
      "ApplicationName": "MyApp",
      "SelectInTransaction": false,
      "CloudTransactions": [
        {
          "TransactionName": "sqlca",
          "CacheName": "MyCache"
        }
      ],
      "Session": {
        "Timeout": 3600
      },
      "Transaction": {
        "Timeout": 3600
      }
    }
  ]
}

I guess that you should modify Session -> Timeout option.

Andreas.