Hello, I need create composite select from hibernate criteria.
Eg. I have slave object
Slave { name; surname; born; }
and object master
Master { locality position List<Slave> slaves }
I need composite select : Select * from Master where slaves in (Slave.name = 'Tomas'), but in Hibernate criteria
List mems = ses.createCriteria(Slave.class).add(Restrictions.eq("name", "Tomas")).list() ses.createCriteria(Master.class).add(Restrictions.in("slaves", mems.toArray())).list()
But I get exception , because select is failed : Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query Caused by: java.sql.SQLException: No value specified for parameter 1
Can you help me make right composite select please?
Regards Tomas
|