Question

10
Replies
3946
Views
AmitShekhar Member since 2016 3 posts
Posted: 5 years ago
Last activity: 4 years 7 months ago
Closed
Solved

Connecting to external SQL database

Hello,

We are connecting to an external SQL database and seeing weird behavior with the SQL driver.

PRPC is running on oracle database and so for connecting to SQL additional jar file was added. We are using Pega cloud servers.

After few hours of non usage of this external connection somehow the test connection is failing. Usually observed after overnight:

Testing Database connection gives failure.

TestDBFail.png

Then I go and check in SMA for the java class name “com.microsoft.sqlserver.jdbc.SQLServerDriver”, expecting that the class should not be there as the test connection is not working.

Here it finds the class:

TestDBlookup.png

 

And then I again try to test connection to make sure I still see the Test Connection error. But, this time it gets connected successfully.

TestDBSuccess.png

Not sure how just searching for the class name fixes it up.

Has anyone seen this issue? Any suggestions about what may be causing this

We are on 7.1.8

 

 

System Administration
Moderation Team has archived post
Share this page LinkedIn