If you're using JBoss-3.0.0, then update the standardjbosscmp-jdbc.xml file in your conf directory.
Now I have the FK's created.
Still one problem remaining though.
I have the 1:1 relationship direction Order --> Shipment.
So I have the field in the Order side of the relationship.I have 'NO' <cmr-field> on the shipment side.
Order Table created is fine. But my Shipment table created is as below
Field 1: SHIPMENT(PK)
Field 2: CITY
Field 3: ZIPCODE
Field 4: ORDERS_SHIPMENT (FK to Order.OrderID)
Why is this? How do i get rid of this extra field. I do not have this in my <cmp-field>'s.