I have an HQL query that looks like this:
<query name="com.rsm.dao.hibernate.UserDAOHibernate.users.by.userNames"><![CDATA[from com.rsm.domain.usermanagement.PersonImpl as user where user.userName in elements(:userNames)]]></query>
With the following code using it below:
public List getUsersByUserNames(List userNames) throws DAOException {
List users = null;
if(userNames!=null) {
String[] paramNames = {"userNames"};
Object[] paramValues = {userNames};
Type[] typeParams = {Hibernate.SERIALIZABLE};
users = getHibernateTemplate().
findByNamedQuery(
"com.rsm.dao.hibernate.UserDAOHibernate.users.by.userNames",
paramNames,
paramValues,
typeParams);
}
return users;
}
I get the following error:
Named parameter does not appear in Query: userNames [from com.rsm.domain.usermanagement.PersonImpl as user where user.userName in elements( :userNames )]; nested exception is net.sf.hibernate.QueryException: Named parameter does not appear in Query: userNames [from com.rsm.domain.usermanagement.PersonImpl as user where user.userName in elements( :userNames )]
Is there an issue with using named parameters inside the elements function?
|