error reading CLOB from Oracle

[nruivo]

Hi,

I'm new to JasperReports, and one of the first things I've tried is to read a CLOB from a table.

It gives me the following error:

 

ErrorÂfillingÂprint...Âjava.lang.AbstractMethodError:Âoracle.jdbc.driver.OracleResultSetImpl.getClob(I)Ljava/sql/Clob;Ânull

java.lang.AbstractMethodError:Âoracle.jdbc.driver.OracleResultSetImpl.getClob(I)Ljava/sql/Clob;Â ÂÂÂÂatÂnet.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:224)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:813)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:777)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1312)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:791)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:695)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)Â ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)Â ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:943)Â ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource)Â

 

Thanks in advance,

Nuno Ruivo

[Teodor Danciu]

Hi,

 

I think the problem is with the Oracle JDBC driver you are using. It seems to be an old version that does not implement that abstract method.

Note that JR requires a JDBC 2.0 compatible driver.

 

I hope this helps.

Teodor