java.sql.SQLException: Failed to calculate index value ...

[deezzub]

I use the HXTT DBF driver in iReport. I get the following exception in iReport if I use a subdataset for a list element. I have done, what you can see in the Video "iReport List Component ". Now, I'm unsure if it is a bug in the HXTT DBF JDBC driver.

Is it a bug?

Code: Select all

Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2
Setting up the file resolver...
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:139)
    at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:129)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:328)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:377)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:351)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2039)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:771)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:281)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)
    at net.sf.jasperreports.components.list.FillDatasetRun.start(FillDatasetRun.java:157)
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:93)
    ... 17 more
Caused by: java.sql.SQLException: Failed to calculate index value for index expression datum
    at com.hxtt.global.SQLState.SQLException(Unknown Source)
    at com.hxtt.sql.dbf.w.a(Unknown Source)
    at com.hxtt.sql.dbf.j.a(Unknown Source)
    at com.hxtt.sql.a1.a(Unknown Source)
    at com.hxtt.sql.cm.a(Unknown Source)
    at com.hxtt.sql.az.a(Unknown Source)
    at com.hxtt.sql.dl.a(Unknown Source)
    at com.hxtt.sql.dl.a(Unknown Source)
    at com.hxtt.sql.c3.g(Unknown Source)
    at com.hxtt.sql.dl.a(Unknown Source)
    at com.hxtt.sql.br.a(Unknown Source)
    at com.hxtt.sql.ai.a(Unknown Source)
    at com.hxtt.sql.dn.executeQuery(Unknown Source)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239)
    ... 21 more
Print not filled. Try to use an EmptyDataSource...