Error: "No suitable driver found for" When testing sdm_ds in JasperReport server 7.x
search cancel

Error: "No suitable driver found for" When testing sdm_ds in JasperReport server 7.x


Article ID: 228560


Updated On:


CA Service Desk Manager CA Service Management - Service Desk Manager


The following error appears after testing sdm_ds in JasperReport server 7.x

Caused by: java.sql.SQLException: No suitable driver found for jdbc:sdm:bop:@[EXAMPLE SDM SERVER]:2100;impersonateUserUuid=[EXAMPLE UUID]
 at java.sql.DriverManager.getConnection(
 at java.sql.DriverManager.getConnection(
 at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(
 ... 209 more
ERROR SecureExceptionHandlerImpl,http-nio-8081-exec-10:116 - jsexception.error.creating.connection

The connection works OK in JasperStudio.

The integration worked OK with no error messages.


Release : 17.3

Component : SDM - Reporting/BOXI/JasperSoft


IPv4 is being used in the environment


Browse the Jasper Tomcat bin and run below command:

tomcat9w.exe //ES//jasperreportsTomcat

Under the Java tab add the following option to the java options section as shown below: 


Restart jasper services and test the connection.


In IPv6 environment:

Go to NX.env  and add the entry @NX_PROTOCOL_ONLY=MIXED to the file.  Restart SDM services after making the change.