AnsweredAssumed Answered

JR Exception Error after parameter creation

Question asked by julian.kim on Jun 6, 2016
Latest reply on Jun 10, 2016 by Chris_Hackett

I get the following error after I added the parameter into the SQL in the Jaspersoft Studio

DescriptionResourcePathLocationType
Build path specifies execution environment JavaSE-1.6. There are no JREs installed in the workspace that are strictly compatible with this environment.MyReportsBuild pathJRE System Library Problem

 

 

I'm not sure what to do here.

 

 

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4_Landscape.

  at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:506)

  at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:481)

  at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:362)

  at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4_Landscape.

  at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)

  at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)

  at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)

  at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)

  at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)

  at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

  at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: [TIBCO][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended

 

 

  at tibcosoftwareinc.jdbc.oraclebase.ddcr.b(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.ddcr.a(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.ddcq.b(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.ddcq.a(Unknown Source)

  at tibcosoftwareinc.jdbc.oracle.ddal.a(Unknown Source)

  at tibcosoftwareinc.jdbc.oracle.ddal.a(Unknown Source)

  at tibcosoftwareinc.jdbc.oracle.ddam.t(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.dde3.w(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.dde3.v(Unknown Source)

  at tibcosoftwareinc.jdbc.oraclebase.dddz.executeQuery(Unknown Source)

  at tibcosoftware.jdbc.common.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:45)

  at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)

  ... 6 more

Outcomes