https://community.qlik.com/t5/Talend-Studio/TjasperOutput-with-tOracleInput-unknown-column/m-p/2367392#M130774 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. <BR />This blog post describes an Access/Jasper Report job I created that uses the tJasperOutput component to produce a PDF. <BR /> <A href="http://bekwam.blogspot.com/2011/05/using-talend-as-datasource-for-jasper.html" rel="nofollow noopener noreferrer">http://bekwam.blogspot.com/2011/05/using-talend-as-datasource-for-jasper.html</A> Mon, 03 Oct 2011 13:47:56 GMT Anonymous 2011-10-03T13:47:56Z https://community.qlik.com/t5/Talend-Studio/TjasperOutput-with-tOracleInput-unknown-column/m-p/2367391#M130773 I try to use a tjasperOutput from a tOracleInput on java project but this not work. <BR />The jasper works on ireport... <BR />03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse <BR />ATTENTION: No pattern provided, using default. <BR />03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse <BR />ATTENTION: No pattern provided, using default. <BR />03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse <BR />ATTENTION: No pattern provided, using default. <BR />03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse <BR />ATTENTION: No pattern provided, using default. <BR />03-oct.-2011 9:28:33 org.apache.commons.beanutils.locale.converters.DecimalLocaleConverter parse <BR />ATTENTION: No pattern provided, using default. <BR />Exception in component tJasperOutput_1 <BR />net.sf.jasperreports.engine.JRException: Unknown column name : DATE_MOUVE <BR /> at net.sf.jasperreports.engine.data.JRCsvDataSource.getFieldValue(JRCsvDataSource.java:231) <BR /> at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:873) <BR /> at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:841) <BR /> at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1439) <BR /> at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127) <BR /> at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903) <BR /> at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:832) <BR /> at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84) <BR /> at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) <BR /> at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:540) <BR /> at datawarehouse.test_jasper_0_1.test_jasper.tOracleInput_2Process(test_jasper.java:1259) <BR /> at datawarehouse.test_jasper_0_1.test_jasper.runJobInTOS(test_jasper.java:3960) <BR /> at datawarehouse.test_jasper_0_1.test_jasper.main(test_jasper.java:3807) <BR />All column are there, Any ideas ?? Sat, 16 Nov 2024 12:38:44 GMT https://community.qlik.com/t5/Talend-Studio/TjasperOutput-with-tOracleInput-unknown-column/m-p/2367391#M130773 Anonymous 2024-11-16T12:38:44Z https://community.qlik.com/t5/Talend-Studio/TjasperOutput-with-tOracleInput-unknown-column/m-p/2367392#M130774 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. <BR />This blog post describes an Access/Jasper Report job I created that uses the tJasperOutput component to produce a PDF. <BR /> <A href="http://bekwam.blogspot.com/2011/05/using-talend-as-datasource-for-jasper.html" rel="nofollow noopener noreferrer">http://bekwam.blogspot.com/2011/05/using-talend-as-datasource-for-jasper.html</A> Mon, 03 Oct 2011 13:47:56 GMT https://community.qlik.com/t5/Talend-Studio/TjasperOutput-with-tOracleInput-unknown-column/m-p/2367392#M130774 Anonymous 2011-10-03T13:47:56Z