Hi, i develop a java project to create some pdf report containing DB data. When i run it on eclipse i don't have any problems and my report is created. Now i create a jar file of my project. When i run it, it seems that i couldn't connect to DB and i have this error C:\tmp>java -cp Report.jar;config\config.properties;lib\classes12.jar;lib\common s-beanutils-1.8.3.jar;lib\commons-collections-3.2.1.jar;lib\commons-logging-1.1. 1.jar;lib\dom4j-1.6.1.jar;lib\itext-1.3.1.jar;lib\jasperreports-3.0.0.jar;lib\jx l-2.6.8.jar;lib\poi-3.1-beta2.jar;. jasper.Report.main.ProvaReport /C:/tmp/config/config.properties 30-apr-2010 16.14.55 net.sf.jasperreports.engine.fill.JRFillSubreport prepare GRAVE: Fill 22172629: exception net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Pro va2 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasourc e(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource( JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillD ataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFil ler.java:1196) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 833) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare dStatement.java:795) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme nt.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa redStatement.java:835) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1123) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:3328) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasourc e(JRJdbcQueryExecuter.java:135) ... 9 more net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JREx ception: Error executing SQL statement for : Prova2 at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubrep ort.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElemen ts(JRFillElementContainer.java:344) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVe rticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVertic alFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRV erticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVertic alFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63 ) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillMa nager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillMa nager.java:363) at jasper.Report.model.JasperReportCreator.createQueryReport(JasperRepor tCreator.java:104) at jasper.Report.model.ConsuntivazioneAction.generaReport(Consuntivazion eAction.java:58) at jasper.Report.main.ProvaReport.main(ProvaReport.java:29) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statemen t for : Prova2 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasourc e(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource( JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillD ataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFil ler.java:1196) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 833) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java: 782) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFill Subreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportR unnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThread SubreportRunner.java:209) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:212) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare dStatement.java:795) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme nt.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa redStatement.java:835) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1123) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:3328) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasourc e(JRJdbcQueryExecuter.java:135) ... 9 more It seems that table does not exist but i'm sure that the table is into the DB. Please help me. Thank you very much. Carlo.
