Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Database Table connection error

SA-45316

Summary



User reports that they have changed the Database rule from 'use JDBC URL listed below' to 'use JDBC Connection Pool' and this does not work due to the error on test connection on the database rule.

Oracle 12c is used to host the external schema.


Error Messages



Connection Problem: Class MyOrg-Data-Class is mapped to table WRONG_SCHEMA_NAME.MY_TABLE_NAME which contains no columns


Steps to Reproduce

  1. Add a JDBC datasource for the external database.
  2. Add the necessary database driver in the classpath.
  3. Define a Database Table rule to 'use JDBC Connection Pool' and do not mention the schema name.
  4. Perform the test connection for the database rule.


Root Cause



A defect in Pegasystems’ code or rules:

Oracle synonyms have been only passively supported within the platform, and historically there have been a number of issues surrounding the use of synonyms within the Pega platform.


Resolution



Perform the following local-change:


Use the defaultSchema settings within either Application Server specific configuration setting, like Tomcat's context.xml or the User's prconfig.xml file to define the default schema for the given Data-Admin-DB-Name.

This would make it so that all queries against the given Data-Admin-DB-Name would be schema qualified with the provided schema name. This would give the User a single place to update their schema information should the value change in the future.

To change the value in the context.xml file, a setting such as the following can be used:


<Environment name="prconfig/database/databases/<Name of Data-Admin-DB-Name>/defaultSchema" value="<Name Of Schema>" type="java.lang.String" />

If the value is to be set in the prconfig.xml file, the setting can be formatted as follows:

<env name="database/databases/<Name of Data-Admin-DB-Name>/defaultSchema" value="<Name Of Schema>" />

Published March 8, 2018 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us