Classpath not found exception

[mohammed.javeed]

Java Version : JDK 11

Encountered below exception while integration of Apache Calcite Avatica JDBC 

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: org.apache.calcite.avatica.remote.Driver cannot be found by net.sf.jasperreports_6.20.1.final
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:199)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:125)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:120)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:153)
    at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:50)
    at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.apache.calcite.avatica.remote.Driver cannot be found by net.sf.jasperreports_6.20.1.final
    at org.eclipse.osgi.internal.loader.BundleLoader.generateException(BundleLoader.java:541)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass0(BundleLoader.java:536)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:416)
    at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:168)
    at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
    at java.base/java.lang.Class.forName0(Native Method)
    at java.base/java.lang.Class.forName(Unknown Source)
    at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:208)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:158)
    ... 5 more
 

 

Note : Same driver jar is attached to Jasper reports server and connection was successfull.

[Swapnil Pawar]

Hello,

Please let us know which version of java are you using.

Make sure you are on the supported version of java.

Please go through the below attached platform support guide: https://docs.tibco.com/pub/js-jrs/8.1.0/doc/pdf/TIB_js-jrs_8.1.0_Platform-Support-Commercial-Edition.pdf?id=0

Thanks!

[Tom C]

Try org.apache.calcite.jdbc.Driver