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.
Release : 17.x
Component : SDM - Reporting/BOXI/JasperSoft
JaserReport Server 7.x, 8.x, 9.x
IPv4 is being used in the environment
Browse the Jasper Tomcat bin E.G "C:\Jaspersoft\jasperreports-server-9.0.0\apache-tomcat\bin" and run below command:
jasperreportsTomcatw.exe
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.