[nbj2ee] Facing problem when compiling report in jasper iReport tool. Help me

  • From: "jamal.abbasi" < >
  • To:
  • Subject: [nbj2ee] Facing problem when compiling report in jasper iReport tool. Help me
  • Date: Thu, 11 Oct 2012 03:02:53 -0400

I design report in jasper iReport and made connection with oracle all works 
fine but when i compile the report its gives error, Kindly check the error 
log and tell me where i am doing mistake.

HERE ERROR LOG...


Error filling print... Error executing SQL statement for : 
client_log_enquiry 
net.sf.jasperreports.engine.JRException: Error executing SQL statement 
for : client_log_enquiry  Â Â Â Â at 
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:676)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:596)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1223)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:853)  Â 
   at 
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)  Â 
   at 
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)  Â Â 
  at 
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251)Â
  Â Â Â!
  Â at 
com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:896)Â
  Â Â Â Â at 
org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)  Â Â Â 
 at 
org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)  

Caused by: java.sql.SQLException: ORA-00920: invalid relational 
operator Â  Â Â Â Â 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:744)  Â Â Â Â at 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:218)Â
  Â Â Â Â at 
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:812)Â
  Â Â Â Â at 
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1048)Â
  Â Â Â Â at 
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:853)Â
  Â Â Â Â at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)Â
  Â Â Â Â at 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:!
 3369)  Â Â Â Â at 
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3414)Â
  Â Â Â Â at 
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)






[nbj2ee] Facing problem when compiling report in jasper iReport tool. Help me

jamal.abbasi 10/11/2012

Project Features

About this Project

www was started in November 2009, is owned by jpirek, and has 21 members.
By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20131025.e7cbc9d). © 2013, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
 
 
Close
loading
Please Confirm
Close