Skip to main content

Support Article

Issue connecting to external database using Database rule

SA-32913

Summary



User is attempting to install SQL Server drivers on JBoss for a Pega installation in order to connect to an external database using a Database rule.

Despite installing the drivers, the database connection test fails, stating it cannot find the driver.

Error Messages



Not Applicable


Steps to Reproduce

  1. Configure JBoss standalone-full.xml with datasource definition for JDBC connection to the Sql Server driver.
  2. Test connection from JBoss admin console to verify the configuration is correct.
  3. Create a Database record in Pega developer portal.
  4. Use 'JDBC URL listed below' option and specify the jdbc connection information.
  5. Click Test Connectivity.


Root Cause



A defect or configuration issue in the operating environment.

Although JBoss app server is configured correctly to connect to this external database and a JNDI name for this connection is exposed within JBoss container, Pega is not instructed to use 'JDBC Connection Pool' option that will work with this setting.

Resolution



Here’s the explanation for the reported behavior:

Use 'JDBC Connection Pool' option and specify the JNDI name from JBoss standalone-full.xml. Then verify the same by clicking on Test Connectivity button.

Suggest Edit

Published February 10, 2017 - Updated October 8, 2020

Did you find this content helpful?

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.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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