No suitable driver found for jdbc during SDM/Jasper integration
search cancel

No suitable driver found for jdbc during SDM/Jasper integration

book

Article ID: 413266

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

Integrating SDM with Jasper, during the Data source test, receiving error:

java.sql.SQLException: No suitable driver found for jdbc:sdm:bop:@[sdm-server]:2100;impersonateUserUuid= at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) 

Environment

SDM 17.4 RU2 and above / Jasper 9.0

Cause

The JDBC jar file included in the install was not the version specified in the documentation.

Resolution

Existing documentation specifies JDBC drivers to be downloaded ahead of the Jasper install.  Usage of any versions other than the version specified may not work correctly.  

For instance, using a version of the MSSQL JDBC driver other than the specified version in the documentation, may result in this error.

Additional Information

For the jar and xml files, review the following locations in the Jasper install to confirm they are present and updated. A simple way to filter for the updated files is to sort by date order.  The newer files will be from the date/time of the install and integration where the other files will be at least the year 2024.

The following example assumes an install/integration date of Jan 9, 2025:

Working Jasper instance should have for jar files:

[JASPER INSTALL DIR]\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib
01/09/2025  08:45 PM           340,288 BOPIntegration.jar
01/09/2025  08:45 PM            39,138 cabi-jasperreportsserver-commonutil.jar
01/09/2025  08:45 PM             8,487 cabi-jasperreportsserver-dynamicjdbc.jar
01/09/2025  08:45 PM             9,558 cabi-jasperreportsserver-rolebasedflow.jar
01/09/2025  08:45 PM            59,497 cabi-jasperreportsserver-sso.jar
01/09/2025  08:45 PM            12,827 cabi-jasperreportsserver-userlocale.jar
01/09/2025  08:45 PM             8,591 cabi-jasperreportsserver-versionapi.jar
01/09/2025  08:45 PM            17,158 domsrvr_utils.jar
01/09/2025  08:45 PM           125,656 sd-utils.jar
01/09/2025  08:45 PM           126,172 slump.jar

Working Jasper instance should have for XML files:

[JASPER INSTALL DIR]\apache-tomcat\webapps\jasperserver-pro\WEB-INF

01/08/2025  08:49 PM             2,253 jboss-web.xml
01/08/2025  08:49 PM            31,021 web.xml
01/09/2025  08:45 PM           135,451 applicationContext.xml
01/09/2025  08:45 PM            51,052 applicationContext-el-operators.xml
01/09/2025  08:45 PM            10,788 applicationContext-externalAuth-template-mt.xml
01/09/2025  08:45 PM             9,501 applicationContext-jdbc-metadata.xml
01/09/2025  08:45 PM            35,853 applicationContext-rest-services.xml
01/09/2025  08:45 PM            66,678 applicationContext-security.xml
01/09/2025  08:45 PM            46,053 applicationContext-security-web.xml
01/09/2025  08:45 PM           139,104 applicationContext-semanticLayer.xml