Discussion
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
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.