Hi,
I am very new to the EJB world but trying to develop an application that interacts with a MySQL DB. I have a number of tables which i am relating to one another via foreign keys which i have specified in the jbosscmp-jdbc file and the ejb-jar deployment descriptor. After executing ant on the command line to build my database, I found not only the foreign keys which i specified but other similarly named fields which were automatically included....im thinking from the relationship tags in the ejb-jar file.

Can someone tell me if its necessary to explictly include these foreign keys or does EJBs do it automatically once you have specified the relationship in the deployment descriptor? Do i even have to explicitly have to include primary keys?

Cheers
Fiona