BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题

用birt设计一个报表,使用了三个参数,但是使用了dataset的beforeOpen事件之后,总是报错如下:

An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Data Set
Cannot set the string value (d) to parameter 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set preparedStatement parameter string value.
SQL error #1:Parameter index out of range (1 > number of parameters, which is 0).
 ;
    java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Data Set
Cannot set the string value (d) to parameter 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set preparedStatement parameter string value.
SQL error #1:Parameter index out of range (1 > number of parameters, which is 0).
 ;
    java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
	at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1245)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1224)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)

捣鼓了半天最后发现是把+=写成了=,导致this.queryText原始的sql语句被覆盖了,真实晕,还以为是bug.


正确的js脚本如下

var clause = reportContext.getParameterValue("searchClause");
if(clause!=null){
	this.queryText += clause;
}