Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

ordinal parameter mismatch

Description

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

Attachments

1

Activity

Show:

Steve Ebersole March 21, 2011 at 6:59 PM

Closing stale resolved issues

ArturA January 30, 2006 at 4:28 PM

Runnable test case in attachment.

Steve Ebersole January 27, 2006 at 10:00 PM

Cannot reproduce and you attached no runnable test case.

Incomplete

Details

Assignee

Reporter

Components

Affects versions

Priority

Created January 27, 2006 at 7:43 PM
Updated March 21, 2011 at 6:59 PM
Resolved January 27, 2006 at 10:00 PM