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

Hibernate version:
2.1.7

Mapping documents:

Code between sessionFactory.openSession() and session.close():

net.sf.hibernate.Query hQuery = session.createQuery("FROM obsRequest in class test.app.persistencebeans.ObservationRequest WHERE obsRequest.person in elements(:personList) and obsRequest.storageStatus = :storageStatus");
hQuery.setString("storageStatus", "O");
hQuery.setParameterList("personList", personnel);
query = new HibernateQuery(hQuery);

//where personnel is a list of Person Objects

Full stack trace of any exception that occurs:

test.app.persistence.PersistenceException: net.sf.hibernate.QueryException: Named parameter does not appear in Query: personList0_ [FROM obsRequest in class test.app.persistencebeans.ObservationRequest WHERE obsRequest.person in elements(:personList0_) and obsRequest.storageStatus = :storageStatus]
at test.app.persistence.hibernate.HibernatePersister.fetch(HibernatePersister.java:219)



Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi,

elements is not required in the query if i am right.

for eg.,
Query q = sess.createQuery("from DomesticCat cat where cat.name in (:namesList)");
q.setParameterList("namesList", names);
List cats = q.list();

Also do Look into this,
http://forum.hibernate.org/viewtopic.ph ... 86f3a48abc

Thanks. removing the 'elements' keyword worked!