***Resolved**** Unable to Connect to specified Schema using the Connection

Prashant Gade

• November 07, 2022 16:04
• Edited

In Settings.lgx file we are trying to establish Database Connection using the below. Even though we specified the Custom Schema it is connecting to Public schema by default.

How would we have a Connection connecting to a specified Schema. Even we tried with PostgresSQLSchema and CurrentSchema.

<Connection
   CommandTimeOut="600"
   ID="sessionDB"
   PostgreSQLDatabase="<SESSIONS_DB_NAME>"
   PostgreSQLPassword="<SESSIONS_DB_PW>"
   PostgreSQLServer="<SESSIONS_DB_HOST>"
   PostgreSQLUser="<SESSIONS_DB_USER>"
   Schema="<SESSIONS_DB_SCHEMA>"
   Type="PostgreSQL"
/>

0

• 

  Prashant Gade

  • October 20, 2022 21:57

  Were able to get the fix working for connecting to Custom Schema in _Settings.lgx file.
  The updated connection:

  <Connection
     CommandTimeOut="600"
     ID="sessionDB"
     PostgreSQLDatabase="<DB_NAME>?currentSchema=<DB_SCHEMA>"
     PostgreSQLPassword="<DB_PW>"
     PostgreSQLServer="<DB_HOST>"
     PostgreSQLUser="<DB_USER>"
     Type="PostgreSQL"
  />

  0

Please sign in to leave a comment.