Error running query in TIBCO Jaspersoft Studio

Document ID : KB000117594
Last Modified Date : 16/10/2018
Show Technical Document Details
Issue:
The following Exception might be received when running a query in TIBCO Jaspersoft Studio Professional
(Dataset and Query Dialog), when clicking on Data preview tab (Refresh Preview Data)


Exception, if you want to see more information look into details.

Reason: java.lang.Exception: java.lang.ClassNotFoundException: oracle.jdbc.OracleBlob cannot be found by net.sf.jasperreports_6.4.2.final --- 
net.sf.jasperreports.engine.design.JRDesignField@<HEX_NUMBER>
...
at com.jaspersoft.studio.data.reader.DatasetReader.compile(DatasetReader.java:210)
at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:303)
at com.jaspersoft.studio.property.dataset.dialog.DataPreviewTable$5.run(DataPreviewTable.java:312)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Environment:
TIBCO Jaspersoft Studio Professional 6.4.2.final
Cause:
The query contains a select request for one or several fields whose Class Type is "oracle.jdbc.OracleBlob".
This Class Type is not supported by the Driver of the Data Adapter.
Resolution:
To resolve this problem, remove from the list of fields being queried the ones of type "oracle.jdbc.OracleBlob".