My (abstracted) problem is as follows:
In my java domain model I have:
Typically I would tend to model this in the DB as
Now, my problem is, in a desktop swing UI I want to show all the possible Services with all their possible Practitioners. The user can select a subset of the Services and a subset of the Practitioners for each Service and assign those subsets to different Seasons.
How can I map the Service POJO so that in some contexts I load all the practitioners, but when the Service is contained in a Season I only load the selected subset of Practitioners. The question is really, how do I bring that join table between Season and Practitioner in to play?