TjasperOutput with tOracleInput unknown column

One Star

TjasperOutput with tOracleInput unknown column

I try to use a tjasperOutput from a tOracleInput on java project but this not work.
The jasper works on ireport...
03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse
ATTENTION: No pattern provided, using default.
03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse
ATTENTION: No pattern provided, using default.
03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse
ATTENTION: No pattern provided, using default.
03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse
ATTENTION: No pattern provided, using default.
03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse
ATTENTION: No pattern provided, using default.
Exception in component tJasperOutput_1
net.sf.jasperreports.engine.JRException: Unknown column name : DATE_MOUVE
at net.sf.jasperreports.engine.data.JRCsvDataSource.getFieldValue(JRCsvDataSource.java:231)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:873)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:841)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1439)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:832)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:540)
at datawarehouse.test_jasper_0_1.test_jasper.tOracleInput_2Process(test_jasper.java:1259)
at datawarehouse.test_jasper_0_1.test_jasper.runJobInTOS(test_jasper.java:3960)
at datawarehouse.test_jasper_0_1.test_jasper.main(test_jasper.java:3807)
All column are there, Any ideas ??
One Star

Re: TjasperOutput with tOracleInput unknown column

Double-check the query used in the Jasper Report. Make sure that the detail bands are using the same column names as the tOracleInput. Also watch the type definitions. I set all the fields to java.lang.String in iReport.
This blog post describes an Access/Jasper Report job I created that uses the tJasperOutput component to produce a PDF.
http://bekwam.blogspot.com/2011/05/using-talend-as-datasource-for-jasper.html