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

Resolved DB connection: INI file or AEM data source and transaction settings

  1. How-to
0
Votes
Undo
  1. Miguel Alzate
    Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 22 May 2019 18:31 PM UTC

Hi everybody.

How does PowerSever resolve the connection to the database if the application assigns SQLCA parameters from an INI file but AEM specifies different parameters for SQLCA? Which prevails?

If SQLCA is mapped in AEM from a data source, is it necessary, at all, to load the parameters from an INI file? When, then, is it "mandatory" (or "recommended") to read SQLCA properties from the INI file if these are always set in AEM?

Thanks in advance for helping.

Debug PowerServer app
Command line application deploy to PowerServer
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 22 May 2019 19:09 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Miguel;

  PS's "Data Source" normally prevails.

  If you want the application to control more of the SQLCA conversation then either modify the existing DataSource or create another DataSource and set the "Dynamic Database Connection" option to "ON" using PS's AEM console application. This allows PS to use more your SQLCA values.

  Also, the "Extended Options" on the DataSource definition allow you to specify the extra connection parameters you might need. The value should be in this format: "parameter_name=###" where "parameter_name" is the name of the connection parameter, for example, TextSize=64000

  Note: Only the following DBParm parameters are supported: CommitOnDisconnect, CacheName, DelimitIdentifier, DateTimeAllowed, DisableBind, NCharBind, and TrimSpaces.

 Note2: To support DelimitIdentifier parameter, you must set the "Enclose table and column names in double quotes" option in the PS Toolkit's Profile Configuration.

HTH

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 22 May 2019 20:31 PM UTC
Correct ... by default, PS handles all the DBMS interaction via its "DataSource" settings. In the PS Toolkit's App Profile - you mapped to your App's SQLCA to a specific PS DataSource. Hence, PS will always now use that DS's settings no matter what your App's SQLCA states. Othrwise, you would need to configure the DS as per my previous posting.

  1. Helpful
Miguel Alzate
  1. Miguel Alzate
  2. Thursday, 23 May 2019 11:31 AM UTC
Got it Chris! But the question remains: How can I programmatically obtain the DB connection parameters configured in AEM (or in PS Toolkit) to pass them as arguments to a Web service method?

  1. Helpful
mike S
  1. mike S
  2. Thursday, 23 May 2019 13:45 PM UTC
Miguel,

I don't believe that you can get the database connection information from one configured in AEM.

see appeondconfigdatasource

that will allow you to create a connection to a database.

  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.