java - Hibernate Criteria: subquery with IN -

The first question here: I am using the DB2 and Java Hibernate criteria. I need to use one of my sub-parts where the volume and the sub code will be able to use IN . But I do not know the solution: I have it now:

  Criteria. Add (restrictions. Sequel Reciprocation ("{alias} .arnrmb in (Select from FIRBB from ARNRVB where MNIRRBB?)", Millennialhouses (). Toure (), Typierre));  

I get this error:

  2015-03-16 14: 07: 13,566 [error] (SqlExceptionHelper: 147) - The descriptor indicator is not valid is.  

Can anyone help?

It has been set for now:

  CSCMonstexics .NoteApply (Gatewareware)) {StringBinder S.B. = New stringbilder (); ArrayList & LT; String & gt; Warehouse list = new Array list & lieutenant; String & gt; (Milan Warhouse ()); (Int i = 0; i & lt; warehousesList.size (); i ++) {if (i! = Warehouse list. Size () - 1) {sb.append ("'" + warehousesList.get ( I) + "'" + ","); Other {sb.append ("'" + Warehouses List (I) + "' ');}} String Warehouse Quadys = sb.toString (); Criteria. Aid (Restrictions (" {alias} .arnrmb in ( Select arnrvb from the leading, where mgnrvb ("+ warehousesQuery +")) "});}  

I'm still curious to do so!