Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Object Relational Mapping
Conditions for dependent entites on fetching?
posted 10 years ago
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"
Good heavens! What have you done! Here, try to fix it with this tiny ad:
how do I do my own kindle-like thing - without amazon
Boost this thread!
HTTP Status 403 - Access to the requested resource has been denied
Spring/JPA/TopLink 11g extensions
Problems using GenerationType.IDENTITY for in-memory databases
Java Persistence API