Report design not valid with ClassNotFoundException: oracle.sql.OPAQUE exception

Issue Description

After upgrade to 7.5.0, few reports are failing with exception below:

Report design not valid : 1. java.lang.ClassNotFoundException: oracle.sql.OPAQUE

net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. java.lang.ClassNotFoundException: oracle.sql.OPAQUE at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:280) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:152) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:358) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:618) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:2155) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:2818) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.CacheableCompiledReports.getData(CacheableCompiledReports.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:257) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:112) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:71) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at

... ...

Resolution

Found a field in the report, which requires the class "oracle.sql.OPAQUE" that caused the exception.

<field name="PAYLOAD" class="oracle.sql.OPAQUE"/>

To resolve this, an Oracle library contains the "oracle.sql.OPAQUE" class needs to be added in the classpath.

In this case, added ojdbc7.jar to the classpath and the problem resolved. The library required could be different in different environment.