Error executing SQL

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: s.
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: s.
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:342)
    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:437)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException
    at com.jaspersoft.web.rest.JasperRestConnector.executeRequest(JasperRestConnector.java:262)
    at com.jaspersoft.jdbc.driver.JasperPreparedStatement.executeQuery(JasperPreparedStatement.java:52)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:332)
    ... 6 more

shelweb's picture
90
Joined: Mar 1 2017 - 7:51am
Last seen: 2 years 7 months ago

2 Answers:

You have an error in your sql statement.

hozawa's picture
176379
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago

Query works perfect in sqlplus, also when I change the datasource the report builds without issue. The funny thing is that the datasource connects successfully.

shelweb's picture
90
Joined: Mar 1 2017 - 7:51am
Last seen: 2 years 7 months ago
Feedback