File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem IN clause in HQL query
 
Similar Threads
uses a non-entity as target entity in relationship attribute
Eclipselink, oracle 11 and clobs
Sql query in data-config.xml (Solr Apache)
could not execute query
SQLGrammarException