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

Resolved What database an app connects to

  1. Misc
0
Votes
Undo
  1. Miguel Alzate
    Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Saturday, 6 May 2023 20:31 PM UTC

Greetings to the entire community!

I have a web application on PS2020 that receives as arguments the parameters of the database to which the application must connect. The database may vary depending on the scenario from which the application is invoked. The question is:

Considering that they can be different, which database will the application connect to: the one that is sent in the arguments or the one assigned to the application in AEM?

Note: Of course, both DB parameters (arguments' and AEM's) are assigned to SQLCA.

In advance, thank you very much for your help.

PowerServer 2020 with UFT testing
Como fijar la ventana output
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 6 May 2023 21:07 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Miguel;

  The PS middle tier is doing all the DBMS connectivity and basically ignores all your SQLCA settings. What it will check for though is in your DBParm setting for the keyword "CacheName=xxxxxxx". 

  The CacheNames is PS are then each mapped to a specific DB instance. Thus, your App can have each App User instance connect to it's dependant DB instance by setting the CacheName value accordingly.  HTH

Regards ... Chris 

Comment
Miguel Alzate
  1. Miguel Alzate
  2. Saturday, 6 May 2023 21:42 PM UTC
Hello, Chris. Thanks for you answer!



In what you mentioned in you reply, does the 'xxxxxxx' value of the CacheName correspond to a name of a Data Source in AEM?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Saturday, 6 May 2023 22:26 PM UTC
Correct
  1. Helpful
Miguel Alzate
  1. Miguel Alzate
  2. Saturday, 6 May 2023 23:05 PM UTC
Great! Thanks again.
  1. Helpful 1
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.