[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c... ] Pierce Wetter commented on HHH-5126: ------------------------------------ Also, the parenthese should be allowed, then it should expect single values. Query qTwoLogins = em.createQuery( "select u from User u where ou.loginId in (:login1, :login2)" ); Query qCollectionLogins = em.createQuery( "select u from User u where u.login in :logins" ); qTwoLogins.setParameter("login1","testuser1"); qTwoLogins.setParameter("login2","testuser2"); HashSet<String> list= new HashSet<String>(2); list.add("testuser1"); list.add("testuser2"); qCollectionLogins.setParameter("logins",list); BTW, could we fix this soon, its driving me crazy everytime I switch between EclipseLink and Hibernate to try to shake out bugs I have in Hibernate but not EclipseLink. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira