Question

8
Replies
4952
Views
SatoshiO6673 Member since 2017 9 posts
Okahara
Posted: May 27, 2018
Last activity: June 25, 2018
Closed
Solved

When to use "JDBC Connection pool" or "JDBC URL listed below"

Hi,

We are trying to setup an external database connection from Pega 7.3.1. We use JBOSS EAP 7.0.0 for application server. From JBOSS console, we ensured that JDBC connection works (i.e. jdbc:oracle:thin:@//externaldabasehostname:1521/ORCL). However, when we try it from Pega with the selection of "JDBC URL listed below", it throws an error as below:
"Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for xxxx"

I just found the this PDN article (https://pdn.pega.com/support-articles/issue-connecting-external-database-using-database-rule), and I changed the settings from "JDBC URL listed below" to "JDBC Connection Pool". Then it worked fine. I happened to find this JNDI name in the standalone.xml file. I have two questions:

#1. Why does not "JDBC URL listed below" work while "JDBC Connection Pool" works fine? Is this a Pega's defect or am I missing anything?

#2. Which is better to use, "JDBC URL listed below" or "JDBC Connection Pool"?

Thanks,

System Administration Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn