Hibernate Gotcha: java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!

Sharad Jain, Saturday, December 1, 2007 @ 7:39 pm

This can occur for several different reasons. For example, http://opensource.atlassian.com/projects/spring/browse/SPR-1598. Here is how I came across: Missing hibernate mapping file (hbm.xml) in hibernate SessionFactory.

When we forget to list a hibernate mapping file (*.hbm.xml) during SessionFactory creation, it usually fails fast. This fail fast happens since there is another domain-entity mapping that has many-to-one relationship with this class. However, if a given domain-entity is not being referenced by any other entity mapping file, then Hibernate (obviously) will have no knowledge that this entity-exists.

This is fine, but you expect your query to fail with proper error message when any hibernate query method is called in relation to an unlisted entity. For example, I have a User entity in addition to many other entities. For the sake of argument, let us say that no other entity refers to User entity. So, if I list hibernate mapping files (*.hbm.xml) for all entities except User.hbm.xml, SessionFactory creation won't fail. This is fine since SessionFactory has no magical way to figure out how many entity-classes should have their mapping defined and listed.

However, it should fail when I call methods like Session.createQuery("from com.package.User as s where userName=?"). You would expect Hibernate to fail-fast and complain about un-mapped class (com.package.User in this case). It doesn't. Under these circumstances, trying to execute hql query with positional parameter gives "java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!". Trying to run query with named-param will result in 'org.hibernate.QueryParameterException: could not locate named parameter [<paramname>]". None of these errors say anything about the unmapped entity.

Related Services: Java Application Development, Custom Software Development

Related posts:

1. Grails: Delegating to GORM Persistence in Java
2. HSE 1.1 – Hibernate, Spring and Echo2
3. Afraid of LIE (LazyInitializationException)… Don’t Be.
4. A Java Programmer’s transition to Ruby on Rails
5. Using Hibernate with ZK

Comments (2)

Technologies and Platforms

Comments: 2 so far

• Leave a comment
• Comment feed for this post
• TrackBack URL

1. 

   Thank-you

   Comment by Ralph Bosson, Thursday, December 11, 2008 @ 3:33 pm

2. 

   Guys,
   One problem related to this could be check your orm mapping file and look for correct column name mapping. Problem can be solved.

   Comment by Vivek, Wednesday, April 8, 2009 @ 10:38 am

Leave a comment