Question
Softdel
IN
Last activity: 16 Oct 2018 12:03 EDT
Connection with external DB
I am trying to connect to external oracle DB but getting below connection error
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
IN
Hi,
The error("Database-BadDBDef-Missing OracleBD") points out to missing DB itself. Have you followed the steps mentioned in the below link?
https://www.pegaxchange.com/tag/connect-oracle-db-from-pega-7/
just cross check your steps and see, also the JDBC URL is case sensitive so cross check that too.
Thank You.
Softdel
IN
Hi
Thanks for your reply. I checked the steps mentioned in above link. I am using Oracle SQL Developer for connection and default hr user.
it shows proper connection and table data in sql developer. but getting error while trying to connect in pega.
Pegasystems Inc.
IN
Hi,
Usually it should connect if SID is correct and IP is reachable. Are you seeing any error in logs or tracer when you try saving and perform test connectivity?
That might guide us on what is going wrong.
One more thing that SID is case sensitive so just cross check that once if you haven't.
Thank You.
Pegasystems Inc.
IN
Hi,
The driver itself is missing. Follow the 6th step mentioned in the link. It should fix the problem.
https://www.pegaxchange.com/tag/connect-oracle-db-from-pega-7/
Thank You.
Softdel
IN
Hi Shekhar
I checked in tracer and attached the tracer output where it fails.
Can you please tell me why this error is?
when i saved and then checked the test connection I am getting this error
| Status Value: Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:oracle:thin:@localhost:1521:xe |
| Fail |
thanks
sanjeev
Pegasystems Inc.
US
@Sanjeev, the above error will be noticed when the respective ojdbc6.jar/ojdbc7.jar based on your configuration is missing in your server. So you can add this jar file into your server lib directory then perform the restart of jvm and try your usecase.
Hope it will resolve your issue.
Quad Graphics
US
Hi Shekhar,
Do you have an updated URL? The one you have posted a few times (https://www.pegaxchange.com/tag/connect-oracle-db-from-pega-7/) takes me to a page with a bunch of ads, but no content.
Thank you,
John
Pegasystems Inc.
IN
Hi John,
Can you check this URL
https://www.pegaxchange.com/2017/01/27/access-oracle-db-from-pega-7/
Thank You
Pegasystems Inc.
US
HI Sanjeev,
Try to change your JDBC URL to "jdbc:oracle:thin:@db_host:db_port:sid" format instead of slash(/).
Regards
Mahesh