1. mike S
  2. PowerServer
  3. Monday, 22 August 2022 13:20 PM UTC

Does anyone know what the Other Options and Security Options values are for database connections in powerserver 2022?

APIs for managing cache and cache group - - PowerServer 2022 Help (appeon.com)

"otherOptions": "string", "securityOptions": "string",

 

For example, security options can be blank (apparently this means to encrypt and not trust the server certificate), or encrypt can be set to false.  there should be a way to enable encryption and trust the server cert (important for test database servers).


It would be nice to know what the other options are too.

this is the example in the PS 22 help:

 

ls_json='{"cachename":"C1","configuration":{"host":"172.168.13.1","port":1433,"userid":"sa","password":"sqltest","database":"appeonunittest","enablepooling":1,"minpoolsize":0,"maxpoolsize":100,"connectiontimeout":30,"commandtimeout":60,"DynamicConnection":0,"otheroptions":"","connectionlifetime":30,"securityOptions":""}}'



note that the help is incorrect, the example is missing the ConnectionType value (0 for sql server): '"ConnectionType": 0'

Note also that it is unknown what database driver PS2022 is actually using when you connect in this manner.

 

It would also be nice to know what happens if you don't send the full JSON.  If you don't send the maxpoolsize for example, does it create the connection with default (100?), or does it error.  If it uses default values, then what are the default values.

 



There are no replies made for this question yet.
However, you are not allowed to reply to this question.