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
- Configure JBoss standalone-full.xml with datasource definition for JDBC connection to the Sql Server driver.
- Test connection from JBoss admin console to verify the configuration is correct.
- Create a Database record in Pega developer portal.
- Use 'JDBC URL listed below' option and specify the jdbc connection information.
- 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.
Published February 10, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.