Hello,
I'm trying to implement the following in-clause with hibernate:
Code:
SELECT b from BildInfo b WHERE (b.bnr, b.bid) IN ((10,1), (10,2))
I can't figure out how to set the bind variables.
I've tried the implement a composite object "InfoId" with two members (bnr,bid)
and set the parameter list as List<InfoId>. But that doesn't work.
Code:
Query query = session.createQuery("SELECT b from BildInfo b WHERE (b.bnr,b.bid) in :infoids"
query.setParameterList ("infoids", listOfInfoId);
Maybe it is not possible to implement this type of in-clause in hibernate?
I'm using Hibernate 3.6.7
Thanks for any help,
Chris
Login
FAQ
Search