I created an xml:
Code:
<class name="LoadingPlanVO" table="loading_plan">
<id name="id" column="lp_id" type="int" >
<generator class="identity"/>
</id>
<property name="office" column="lp_office" type="string"/>
<property name="bookingId" column="lp_booking_id" type="string"/>
...
Then I tried:
Code:
List lps = session.createCriteria(LoadingPlanVO.class)
.add(Expression.eq("office", office))
.add(Expression.in("bookingIds", bookingIds))
.list().
However, a SQLException raised and i found the sql logged is:
Code:
... WHERE Loadi0_.lp_office=? and [Ljava.lang.String;@1b5139e in (?)
where the bookingId could not be mapped into the sql field name.
Any clue?