Query on many to many relationship

[shoevarek <va...@gmail.com>]

Hello. I have two entities - CodeDecode and Filter with many to many
biderectional relationship. In data model I have dedicated mapping table
that stores code_decode_id and filter_id associtations. In my entity
configuration I have used @JoinTable annotation to specify join and inverse
join columns I selected CodeDecode as an owner of relationship.

I want to retrieve all CodeDecode for which Filter has specified name. I
also want to return that Filter data. I have created a dynamic query that
correctly returns me collection of CodeDecode entities based on different
search criteria. The problem I am facing is that I do not know how to
retrieve only those Filter entities that were requested. I either get all
entities associated with specific CodeDecode (when I use join fetch) or no
filters at all (when I execute separte search just to get specific filter
entity - it is not mapped/associated with CodeDecode entities that are
already loaded in peristsence context).

What is the way of implementing such query using JPA? Would appreciate any
help.



--
View this message in context: http://openjpa.208410.n2.nabble.com/Query-on-many-to-many-relationship-tp7583048.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.