Hello there. Here is my query

Im using struts with ejbs. My datasource is MYSQL.

My app server is JBOSS 3.2.1

I have set it up successfully for CMP.

There are two tables that Im concerned with.

1. Customer

2. Credit card

One custome4r may have many Credit cards

so, in credit card table , there is a FK reference to C_ID (customer ID)

I have CMR Accessor methods in Customer EJB. (public Collection getCards() and setCards())

I have set up MYSQL to auto generate Primary keys.

My question is ...

How does JBOSS manage inserting the relevant Foreign key id (i.e CreditCard.C_ID) when I insert customer details and credit card details.

The situation arises when a new customer needs to sign on with their personal details (that go in to thecutomer table)

and credit card details (that go in to CC table at the same time)

Please help