File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Meet-in-the-middle mapping question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Meet-in-the-middle mapping question" Watch "Meet-in-the-middle mapping question" New topic

Meet-in-the-middle mapping question

Tomor Pupovci

Joined: Oct 18, 2009
Posts: 1
This is my db schema which looks like this:

So a staff (which is a teacher) can teach a specific subject (curriculum) to a specific class (class_id).

As you can see 'teaches' is the table where all the tables meet. I've tried the Dali tool and it did a pretty good job, by producing something like this (The 'Staff' entity, not entirely quoted, just the parts which have to do with 'teaches'):

But this makes problem when I want to persist a new Staff object, which 'teaches' a specific subject (year, class, subject_id) to a specific class_id, because it doesn't know which class_id with which subject go together. Could you please help me with a better solution for this?

Help is appreciated

Thanks in advance,
It is sorta covered in the JavaRanch Style Guide.
subject: Meet-in-the-middle mapping question
It's not a secret anymore!