Support Article
Third party JARs not being recognized
SA-40510
Summary
The user places the following jar files in the endorsed directory as below on all the nodes in production:
a. /usr/local/tomcat/endorsed/barcode4j-2.1.jar
b. /usr/local/tomcat/endorsed/sqljdbc41.jar
c. /usr/local/tomcat/endorsed/zxing.jar
However, the application doesn't seem to be recognizing these JAR files.
Error Messages
Caused by SQL Problems.
Problem #1, SQLState 08001, Error code 0: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://hostname.pegacloud.io:1566;database=PegaRULES;SelectMethod=cursor
at com.pega.pegarules.data.internal.access.ExceptionInformation
.createExceptionDueToDBFailure(ExceptionInformation.java:256)
.createExceptionDueToDBFailure(ExceptionInformation.java:256)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl
.getConnectionFromDatabaseName(ConnectionManagerImpl.java:898)
.getConnectionFromDatabaseName(ConnectionManagerImpl.java:898)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1219)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1161)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:354)
at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.getConnection(ThreadConnectionStoreImpl.java:427)
at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.lookupDBInfo(DatabaseInformationMapImpl.java:309)
at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.get(DatabaseInformationMapImpl.java:256)
at com.pega.pegarules.data.internal.access.DatabaseImpl.getDBInfo(DatabaseImpl.java:6019)
at com.pega.pegarules.data.internal.rd.utils.DatabaseUtils.getDatabaseTypeForClass(DatabaseUtils.java:192)
at com.pega.pegarules.data.internal.rd.utils.CommonUtils.updateClassInformation(CommonUtils.java:550)
... 47 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://hostname.pegacloud.io;database=PegaRULES;SelectMethod=cursor
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl
.getConnectionFromDatabaseName(ConnectionManagerImpl.java:806)
.getConnectionFromDatabaseName(ConnectionManagerImpl.java:806)
Steps to Reproduce
Not applicable.
Root Cause
In Cloud 2.1 installation of 3rd party jar files is not available with custom cloud bundles. Users are able to import jars using Designer Studio directly.
Resolution
Perform the following local-change: Add the following DSS into your system (through Designer Studio only) and test. This example shows a value list with delimiter.
<env name="database/drivers" value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" />
Published August 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.