How to filter entities by their parents in ManyToOne side in Google App Engine
I use Google App Engine. When I try to do a JPA query like this:
SELECT 开发者_如何学JAVAp FROM Participant p
WHERE p.party.id = :partyKey AND p.name=:participantName
I get the following error
Caused by: org.datanucleus.store.appengine.FatalNucleusUserException:
SELECT FROM Participant p WHERE p.party.id = :partyKey AND p.name=:participantName:
Can only reference properties of a sub-object if the sub-object is embedded.
I gave the key of the Party object as a parameter to the "partyKey" named parameter.
The model is like this: Party has multiple Participants.
I want to query a participant based on the party and the name of the participant. I just can't figure out how to filter using the party. What options do I have?
I've also tried the following query:
SELECT FROM Participant p
WHERE p.party = :party AND p.name=:participantName
but it results in the following error:
Caused by: org.datanucleus.store.appengine.FatalNucleusUserException:
SELECT FROM Participant p WHERE p.party = :party AND p.name=:participantName:
Key of parameter value does not have a parent.
You can do ancestor queries by declaring a parent-pk field. You can then filter the child object using that field. Check the part about "parent-pk" in the documentation (and be sure to read this discussion).
Update: For JPA, it seems you would declare it like this:
@Extension(vendorName="datanucleus", key="gae.parent-pk")
private Long parentId;
You might also want to read the Querying with Key parameters blog post.
精彩评论