issue when passing parameter in jasper report (6.1.1) query

[emrizwan]

Hi,

I've created a parameter called paramValue and added to mysql query as below.

when I am running my report, its throwing following error. ( I am adding "and 1=1" on prompt)

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: AttendanceSheet.
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:511)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:486)
    at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:367)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: AttendanceSheet.
    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:523)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

'" and 1 = 1 " order by ce.course_id, sn.session_id' at line 17
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source

I've used ireport 4 version but did'nt have this issue there.

please can you help on how to resolve this in version 6.1.1?

thanks

[zh3ntil]

What does paramValue hold? If you write the default value expression for paramValue here, it will be easy to detect the problem.

[sanbez]

Try to replace "and 1=1" to  and 1=1

[surima.tvs3]

SQL statement is wrong. please check your query.

Please declare the parameter in the query.