Error Connection DB in Products Posted April 30, 2010 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\commons-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\jxl-2.6.8.jar;lib\poi-3.1-beta2.jar;. jasper.Report.main.ProvaReport/C:/tmp/config/config.properties30-apr-2010 16.14.55 net.sf.jasperreports.engine.fill.JRFillSubreport prepareGRAVE: Fill 22172629: exceptionnet.sf.jasperreports.engine.JRException: Error executing SQL statement for : Prova2 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.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(JRFillSubreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.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(T4CPreparedStatement.java:795) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 9 morenet.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Prova2 at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(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(JRVerticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.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(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:363) at jasper.Report.model.JasperReportCreator.createQueryReport(JasperReportCreator.java:104) at jasper.Report.model.ConsuntivazioneAction.generaReport(ConsuntivazioneAction.java:58) at jasper.Report.main.ProvaReport.main(ProvaReport.java:29)Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Prova2 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.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(JRFillSubreport.java:532) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.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(T4CPreparedStatement.java:795) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(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.
Error Connection DB
in Products
Posted
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.