Hi, all.
Please, consider the following situation:
In my Web app, I programmatically fill SQLCA from an INI file and connect to a specific database. In AEM, for the same app, SQLCA connects to a different database.
How does PS resolve this incoherence? Which database connection prevails in runtime, INI’s or AEM’s?
The cache can also be dynamically built by the PS App at run-time and thus require "no" AEM setup or, your Apps can use a predefined cache as set out by AEM. (Note: not all supported PS DBMS types can use the dynamic cache feature).
Many apps only deal with one DB instance so the dedicated Transaction Object mapping is all they need.
I like using cache names for distributed (segmented) DB's, say for "regional" DBs or for various instances of a customer DB (CustA, CustB, ...etc) to keep the datum logically/physically separated.
Regards ... Chris