Hello all,
I have two classes, Owner and Pet.
A Owner has a Pet, but a Pet does not know about it's Owner.

So I am attempting to write a named query in order to find an Owner when I have a Pet.
My thought is that I can take the petId and look through all Owners, look at the Owner's PetList, check if the PetList contains a Pet with the PetId I am looking for, return that Owner.

Query so far...(not correct)


Any hints would be appreciated!

I assume you mean in your entities a Pet object doesn't hold onto its Owner object. On your database table (assuming a standard one-to-many mapping for owner to pet) your pet table should indicate the owner_id for that pet.

Anyway, if my above assumption is correct you can do this:

debunked, thank you for the reply, your first solution seems to be a correct solution. It passes in my DAO test case but it will take other tests to determine if it is working properly.



Yes your assumptions were correct. It is a one-to-many mapping and the Pet object doesn't hold it's Owner object.
I will have to educate myself on the join parameter since that was my missing link.