[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1404) ordinal parameter mismatch

ordinal parameter mismatch -------------------------- Key: HHH-1404 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1404 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.1.1 Environment: Windows XP SP2, JDK 1.5.0_06-b05, Spring 1.2.6, antlr-2.7.6rc1 Reporter: Artur Wronski Priority: Critical Attachments: RecognizerBug.java After migration from Hibernate 3.0.5 to Hibernate 3.1.1. this query fails: StringBuilder q = new StringBuilder("from domain.Order o ") .append("where o.status in (?, ?) and o.paid = ? and o.stockAgreed = ? and ") .append("o.reminderDate is not null and o.orderRecallDate < ? "); return getSession() .createQuery(q.toString()) .setInteger(0, 1) .setInteger(1, 2) .setBoolean(2, false) .setBoolean(3, true) .setTimestamp(4, new Date()) .list(); with exception: org.hibernate.HibernateException: ordinal parameter mismatch at org.hibernate.engine.query.HQLQueryPlan.buildParameterMetadata(HQLQueryPlan.java:225) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:95) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113) Thanks for help, Arthur