Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved AEM vs INI DB connecion parameters

  1. Misc
0
Votes
Undo
  1. Miguel Alzate
    Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 8 December 2020 18:19 PM UTC

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? 

PowerServer 2020 Life Span
PowerServer 2020 Build 2323 64bit and MS 2008 R2
Responses (1)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 8 December 2020 18:55 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

the connection is completely different in powerserver than powerbuilder.  

in powerserver, you set the cache name:

SQLCA.DBParm="CacheName='"  + yourcachename + "'"

 

which controls what database and server you are connecting to

 

the cachename is setup in AEM - and that is where the server and database information is stored

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 8 December 2020 21:12 PM UTC
Hi Mike;

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
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.