No suitable driver found for jdbc during SDM/Jasper integration
Article ID: 413266
Updated On:
Products
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
Feedback
