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

Hibernate version:3.1

Mapping documents:
<query name="PostingListByCategoryId"><![CDATA[
from CategorizedItem ci where ci.id.categoryId in (?)
]]></query>


Name and version of the database you are using:Mysql 5.0

Hi guys,

I got a list of Long value store inside an array or a List. How could this possibly pass into the IN parameter ? I got error mesasge like follow:


[junit] [stufftolet] WARN [main] JDBCExceptionReporter.logExceptions(71) | SQL Error: 0, SQLState: S1009
[junit] [stufftolet] ERROR [main] JDBCExceptionReporter.logExceptions(72) | Statement parameter 1 not set.

pls help ,thanks !

regards,
Mark

my query code is something like below:

public List findPostingList(List allChild) {
return getHibernateTemplate().findByNamedQuery(
"PostingListByCategoryId", allChild);
}

pls help, Thanks !

Change your namedquery like


and the calling code as


But thats purely using Hibernate.
As far as Spring is concerned, I can see an API like
getHibernateTemplate().findByNamedQuery(namedquery, Object value);
Maybe you can create your list and pass it as the value ?

If you are going to use just hibernate, then the first approach mentioned in my previous comment would work, But if you need to use spring, use the named query like


and use the Spring method
findByNamedQueryAndNamedParam as

hey man, Thanks a lot !