Error Connection DB

[charliebrown222]

 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.