Register / Login
Win a copy of
Kotlin in Action
this week in the
this forum made possible by our volunteer staff, including ...
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