Issue connecting to external database using Database rule
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.
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.
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.
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.
0% found this useful