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
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
It's not a secret anymore!