Jump to content

charliebrown222

Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by charliebrown222

    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.

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore