I get the following error after I added the parameter into the SQL in the Jaspersoft Studio
Description | Resource | Path | Location | Type |
Build path specifies execution environment JavaSE-1.6. There are no JREs installed in the workspace that are strictly compatible with this environment. | MyReports | | Build path | JRE 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