File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Problem IN clause in HQL query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Problem IN clause in HQL query" Watch "Problem IN clause in HQL query" New topic

Problem IN clause in HQL query

Oscar Calderon
Ranch Hand

Joined: Nov 27, 2009
Posts: 32
Hi to all, i'm working with Hibernate JPA right now and i have a problem. Basically, i have a named query in my entity, this named query is the next:

The problem is about the IN clause, where i want to find a parameter in a list of the entity (WbkOpcionesMenu). I read some examples where people does opposite, that is, something like:

So i don't know if isn't possible in the way that i want or if i have to change something in my query. Oops, the stack trace is this (ERROR message is in spanish but it means missing expression):

THanks in advance

Wanna grow? Learn, live, love people and enjoy life
I agree. Here's the link:
subject: Problem IN clause in HQL query