Entity Classes from Database

[MarkInLasVegas]

I am trying to create a one to many relationship from tables in a MySQL database.


Child table.

Note: "mech" is short for mechanism.

order_contact_mech
(
ORDER_ID VARCHAR(20) not null primary key,
CONTACT_MECH_PURPOSE_TYPE_ID VARCHAR(20) not null primary key,
CONTACT_MECH_ID VARCHAR(20) not null primary key,
.
.
.

)

-----------------------------------------------------------------------------------

When I select Entity Classes from Database...
I get two classes:

OrderContactMech.java
and OrderContactMechPK.java

How do I Join another table (order_header on Order_Id ) with OrderContactMech when the key fields are in OrderContactMechPK?

------------------------------------------------------------------------------------

Parent table.

order_header
(
ORDER_ID VARCHAR(20) not null primary key,
ORDER_TYPE_ID VARCHAR(20),
.
.
.
)

------------------------------------------------------------------------------------

Why does Netbeans create a separate class with the primary keys (OrderContactMechPK)?

In OrderContactMech.java I have:

@EmbeddedId
protected OrderContactMechPK orderContactMechPK;

What does this mean?

I want to create a one to many relationship from order_header to
order_contact_mech

------------------------------------------------------------------------------------

The important part seems to be:
@EmbeddedId
protected OrderContactMechPK orderContactMechPK;

If you could explain the @EmbeddedId part that should be enough for now. (Don't get overly concerned about table names, upper and lower case letters and underscores.)

A link to an actual example would be best.

Unfortunately, I cannot change the original tables in any way.


Thank you very much.

PS. I am trying this:

@OneToMany(mappedBy = ???)
private Collection<OrderContactMech???> OrderContactMechCollection???;

[Ernie Rael]

On 12/14/2009 12:30 AM, MarkInLasVegas wrote:

[Antonio Vieiro]

There's a foreign key missing somewhere!

On 14/12/09 12:49, Ernie Rael wrote: