That looks like a bug. There shouldn't be a way for you to create bad
variable bindings with jOOQ. Can you narrow down the exact cause of
the bad parameter indexes? If you log the execution of your statement
in TRACE level (using log4j or slf4j), I will see some more
information...
Thanks
Lukas
2011/5/7 FractalizeR <fractali...@yandex.ru>
>
> Also to point out, if the fields's part was named .asField("BlaBlaBla"), then
> query execution throws exception:
>
> Caused by: java.sql.SQLException: Parameter index out of range (3 > number of
> parameters, which is 2).
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
> at
> com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3717)
> at
> com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3701)
> at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4541)
> at
> com.jolbox.bonecp.PreparedStatementHandle.setString(PreparedStatementHandle.java:1029)
> at org.jooq.impl.JooqUtil.bind(JooqUtil.java:273)
> at org.jooq.impl.JooqUtil.bind(JooqUtil.java:289)
> at org.jooq.impl.Constant.bind(Constant.java:96)
> at org.jooq.impl.InCondition.bind(InCondition.java:83)
> at org.jooq.impl.NotCondition.bind(NotCondition.java:76)
> at org.jooq.impl.CombinedCondition.bind(CombinedCondition.java:108)
> at
> org.jooq.impl.ConditionProviderImpl.bind(ConditionProviderImpl.java:169)
> at
> org.jooq.impl.AbstractResultProviderSelectQuery.bind(AbstractResultProviderSelectQuery.java:130)
> at org.jooq.impl.SelectQueryAsField.bind(SelectQueryAsField.java:76)
> at org.jooq.impl.AliasProviderImpl.bind(AliasProviderImpl.java:116)
> at org.jooq.impl.FieldAlias.bind(FieldAlias.java:79)
> at org.jooq.impl.CompareCondition.bind(CompareCondition.java:76)
> at org.jooq.impl.CombinedCondition.bind(CombinedCondition.java:108)
> at
> org.jooq.impl.ConditionProviderImpl.bind(ConditionProviderImpl.java:169)
> at
> org.jooq.impl.AbstractResultProviderSelectQuery.bind(AbstractResultProviderSelectQuery.java:130)
> at org.jooq.impl.AbstractQueryPart.bind(AbstractQueryPart.java:164)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:87)
> at
> org.jooq.impl.AbstractResultProviderQuery.fetch(AbstractResultProviderQuery.java:87)
> at
> org.jooq.impl.AbstractResultProviderQuery.fetchOne(AbstractResultProviderQuery.java:158)
>
> at
> org.jooq.impl.AbstractDelegatingResultProviderQuery.fetchOne(AbstractDelegatingResultProviderQuery.java:145)
>
> And that shouldn't be, I suppose.
