I'm building a query
"from Lease lease where lease.property.propertyId in :properties"

and then using setParameterList("properties", properties);

This works fine if there are properties in the properties object. However, if that collection is empty, then Hibernate causes an error as shown below. I don't think this should be Hibernate's behavior. It seems like it should translate to just () and then notice that the IN clause cannot be satisfied.

Am I doing something wrong or is this just how it works? Is this a bug? Otherwise, I need to add conditional check in my code for whether properties is empty or not.


Hibernate version:
3.0.5

Full stack trace of any exception that occurs:
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: and near line 1, column 91 [from edu.uiuc.cs411.rentalproperty.domain.Lease lease where lease.property.propertyId in]
org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74)
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214)
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:773)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
edu.uiuc.cs411.rentalproperty.struts.action.ApplicationEntryAction.execute(ApplicationEntryAction.java:65)


Name and version of the database you are using:
MySQL

i meant (:properties), but same error

Well, consider what the generated SQL would be. Wouldn't


be an invalid query? HQL is probably no different in this respect.

I had exactly the same problem today.
well, I think hibernate should just parse this part of the query and resolve it to true or 1=1 or something.

or simply use a database that handles this.