between and parameter

[pcouas_1]

betweenHi

If i create an parameter (" and iv.inventory_date BETWEEN $P{periodeDebut2} AND to_date('20121230','YYYYMMDD')") where periodeDebut2 is a String parameter$, i have following error message

 Time zone: Default Error filling print... Error executing SQL statement for : report18
For input string: "" 
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report18 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:287) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:760) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: java.sql.SQLException: ORA-00907: parenthèse de droite absente
 
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) 
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) 
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) 
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799) 
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) 
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) 
    ... 11 more 
Print not filled. Try to use an EmptyDataSource..

But with " and iv.inventory_date BETWEEN '30/12/2012' AND '30/12/2012'" i have no error ?
Where is my mistake ?

How could i see SQL query ?


Regards
Phil

 

between</pre>[/code]

[kkriplani]

(" and iv.inventory_date BETWEEN $P{periodeDebut2} AND to_date('20121230','YYYYMMDD')")

This expression used by you is incorrect.

Try the following and check the result;

"and iv.inventory_date BETWEEN" +$P{periodeDebut2}+ "AND to_date('20121230','YYYYMMDD')"

 

Also, you can check the SQL query running for the reports in the logs (<tomcat>/webapps/jasperserver-pro/WEB-INF/logs), for that you need to make sure the SQL query executer in server settings on the jasperserver is set to debug mode. 

Hope this helps,
KKriplani

[pcouas_1]

Resolved