Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.3

i just upgraded to hibernate 3.1.3 from hibernate 2 and i have been getting this error

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

this is my query


public List getAllAreaOfInterestLabelValueBeans(long userId) {
String query = "SELECT new CoreLabelValueBean(aoi.aoiName, aoi.id) " + "FROM XrefUserRoleAoi as xura, AreaOfInterest as aoi " +
"WHERE aoi.id=xura.aoiId AND xura.userId = ? " +
"ORDER BY aoi.aoiName asc";
return getHibernateTemplate().find(query, new Object[] {new Long(userId)});
}

any thoughts
Fadi

You may want to try to explictly specify the join condition in a join clause instead of leaving it in the where clause. You can see the following for examples

http://www.hibernate.org/hib_docs/v3/re ... hql-select

-- excerpt ---
select new Family(mother, mate, offspr)
from DomesticCat as mother
join mother.mate as mate
left join mother.kittens as offspr


I hope this helps :)

Marius