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

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears after testing sdm_ds in JasperReport server 

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(DriverManager.java:689)
 at java.sql.DriverManager.getConnection(DriverManager.java:247)
 at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:59)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56)
 ... 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.

Environment

Release : 17.x

Component : SDM - Reporting/BOXI/JasperSoft

JaserReport Server 7.x, 8.x, 9.x

Cause

IPv4 is being used in the environment

Resolution

Browse the Jasper Tomcat bin E.G "C:\Jaspersoft\jasperreports-server-9.0.0\apache-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:

-Djava.net.preferIPv4Stack=true 

Example:

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.