Question
EY
IN
Last activity: 29 Mar 2022 14:12 EDT
Accessing Oracle Synonym via External Classes
One of my customer has Oracle DB and synonym created in it. We need to look up this via an external class mapping. Web application is Apache Tomcat. Pega version 8.6. Hosted in AWS. PegaRules/PegaData is in PostgreSQL.
I have tried to add includeSynonyms=true param in Context.xml. While restarting the server, Pega is ignoring this element saying not a valid key word. This configuration is mentioned in https://community.pega.com/support/support-articles/unable-use-synonyms-nbam-schema
Is there a solution to this or Pega can't pick the synonyms yet?
Accepted Solution
Updated: 29 Mar 2022 14:12 EDT
EY
IN
@Subhankar G The issue was not with Synonym. Enable optimization was the root cause for this problem. Please follow the steps mentioned in the article to resolve the issue -
Pegasystems Inc.
IN
Hello @Subhankar G
Did you check out a similar support article related to synonym topic?
https://community.pega.com/support/support-articles/unable-use-synonyms-nbam-schema-0
Thank you!
EY
IN
@PoojaGadige Yes, please read through my original post. I have already tried it.
It is not working -
org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = <DB NAME> Ignoring unknown property: value of "includeSynonyms=true" for "connectionProperties" property
Accepted Solution
Updated: 29 Mar 2022 14:12 EDT
EY
IN
@Subhankar G The issue was not with Synonym. Enable optimization was the root cause for this problem. Please follow the steps mentioned in the article to resolve the issue -