rvanderwerf opened a new issue, #14464:
URL: https://github.com/apache/grails-core/issues/14464

   I have an example app to show the issue. Just start it and bootstrap will 
fail. I have 3 levels of objects using multi-tenant support (subdomain based). 
Anyhow when I do a query from a child object for related objects I get a SQL 
error that one of the parameters (the IN statement criteria) is missing.
   
   ```
   Caused by: org.h2.jdbc.JdbcSQLException: Parameter "#2" is not set; SQL 
statement:
   select this_.id as id1_3_0_, this_.version as version2_3_0_, this_.tenant_id 
as tenant_i3_3_0_, this_.date_created as date_cre4_3_0_, this_.last_updated as 
last_upd5_3_0_, this_.name as name6_3_0_, this_.activity as activity7_3_0_, 
this_.date_trashed as date_tra8_3_0_ from contact_activity this_ where 
this_.date_trashed=? and this_.id in (?) [90012-193]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.expression.Parameter.checkSet(Parameter.java:81)
        at org.h2.command.Prepared.checkParameters(Prepared.java:164)
        at org.h2.command.CommandContainer.query(CommandContainer.java:109)
        at org.h2.command.Command.executeQuery(Command.java:201)
        at 
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)
        at 
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
        ... 88 common frames omitted
   ```
   This example has a namedQuery but also I've tried where queries and regular 
criteria queries with the same result.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to