org.hibernate.MappingException: Unknown entity: java.util.ArrayList

Question

I tried to map the groupIds list into the sqlrestriction below but got the error. How should I map it?

 List<String> groupIds = new ArrayList<String>();
  ...
  ...

    Restrictions.sqlRestriction(
       "{alias}.id in (select id from table where group_id in ?)",
       groupIds, Hibernate.OBJECT
    )

Please post the complete entity, also let us know is it a joined table or what — Ankur Singhal, Aug 26 '14 at 05:58
One way is to set comma separated group id manually in one string variable and use this string variable in IN CLAUSE — Viraj Dhamal, Aug 26 '14 at 06:35

score 0 · Answer 1 · answered Aug 26 '14 at 05:57

0

Unfortunately Hibernate does not automatically expand non-persistent collections in query conditions. You have to enlist the single groupId's manually.

answered Aug 26 '14 at 05:57

user1071093

1

org.hibernate.MappingException: Unknown entity: java.util.ArrayList

1 Answers1