This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Conditions for dependent entites on fetching? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Conditions for dependent entites on fetching?" Watch "Conditions for dependent entites on fetching?" New topic
Author

Conditions for dependent entites on fetching?

Johann Dobbins
Ranch Hand

Joined: Oct 16, 2008
Posts: 63
I am trying to execute a JPQL query using toplink, where an entity fetches its dependent entities, but would like to filter those entities based on status. Situation is as follows:

Customer class has a set of numbers
Number class has a status which can be 0, or 1

to select a customer with a certain id:

SELECT c FROM Customer c left join fetch c.numbers n WHERE n.status = 0 AND c.id = ?id

gives a toplink exception, "unexpected token: n"
 
Have you checked out Aspose?
 
subject: Conditions for dependent entites on fetching?
 
It's not a secret anymore!