Discussion

1
Replies
289
Views
 Tanmaya Mendhekar (tmendhekar)
JP Morgan Chase

JP Morgan Chase
IN
tmendhekar Member since 2008 9 posts
JP Morgan Chase
Posted: January 5, 2016
Last activity: January 23, 2016
Posted: 5 Jan 2016 3:14 EST
Last activity: 23 Jan 2016 13:43 EST
Closed

database test connectivity error

We are getting the following error while doing a Database Test connectivity.

PRPC version: V5.5 Sp1.

The compile/DefaultPaths setting is having the reference to ojdbc jar as well.

Please provide suggestions to circumvent the error

java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseConnectionProperties
    at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager.java:419)
    at java.sql.DriverManager.getConnection(DriverManager.java:467)
    at com.pega.pegarules.engine.database.ConnectionManager.getConnectionWithPreferenceConfig(ConnectionManager.java:1544)
    at com.pega.pegarules.engine.database.DatabaseImpl.testConnection

 

System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 5 years ago
Posted: 23 Jan 2016 13:43 EST
Lee Pederson (pedel)
PEGA
Global Tech Enablement, Principal Instructor - LSA
Pegasystems Inc.
US

An "ojdbc jar" such as ojdbc6.jar or ojdbc7.jar is used to connect to an Oracle database.


To connect to a Microsoft SQL Server database you would use an "sqljdbc jar" such as sqljdbc4.jar, sqljdbc41.jar, or sqljdbc42.jar.


Make certain the driver jar that you specify matches the database to which you want to connect.