Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
Conditions for dependent entites on fetching?
posted 8 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"
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