I think that a table is created by an entity bean when it's deployed. I have two entity bean(Administrator and Main_Project) that is related to each other(one-many relationship). so when it's deployed, i have two tables created(Administrator and main_project). but the table 'main_project' has "AdministratorEJB_mainProjects" column which is a foreign key.
is there any way to give it a name that i want? i know if i change it, it might not work.. so is there any element to define it in ejb-jar.xml?
All the fields mapping (cmp and cmr with column names) are defined in jbosscmp-jdbc.xml
For a relationship, you can specify a <column-name> tag in the <key-field> tag within the appropriate <ejb-relationship-role> tag.
If you are using XDoclet (the best way):
@jboss.relation fk-column=<your column name>