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

最新推荐文章于 2023-11-23 23:18:48 发布

原创最新推荐文章于 2023-11-23 23:18:48 发布 · 3.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#birt parameter

本文介绍了一个在使用BIRT报表设计过程中遇到的问题：在设置了三个参数并使用了dataset的beforeOpen事件后，出现无法设置字符串值到参数1的异常。通过检查发现是因为将拼接符号误写导致SQL语句被错误地修改。

用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;
}