<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd"> <jbosscmp-jdbc> <defaults> <datasource>java:/CMRDemo</datasource> <datasource-mapping>MS SQLSERVER</datasource-mapping> <create-table>false</create-table> <remove-table>false</remove-table> <pk-constraint>true</pk-constraint> <preferred-relation-mapping>foreign-key</preferred-relation-mapping> </defaults> <enterprise-beans> <entity> <ejb-name>Book</ejb-name> <table-name>Book</table-name> <cmp-field> <field-name>bookId</field-name> <column-name>BookId</column-name> </cmp-field> <cmp-field> <field-name>bookName</field-name> <column-name>BookName</column-name> </cmp-field> <cmp-field> <field-name>price</field-name> <column-name>Price</column-name> </cmp-field> </entity> <entity> <ejb-name>Category</ejb-name> <table-name>Category</table-name> <cmp-field> <field-name>catId</field-name> <column-name>CatId</column-name> </cmp-field> <cmp-field> <field-name>catName</field-name> <column-name>CatName</column-name> </cmp-field> </entity> </enterprise-beans> <relationships> <ejb-relation> <ejb-relation-name>Book-Category</ejb-relation-name> <foreign-key-mapping/> <ejb-relationship-role> <ejb-relationship-role-name>Category</ejb-relationship-role-name> <key-fields> <key-field> <field-name>catId</field-name> <column-name>CatId</column-name> </key-field> </key-fields> </ejb-relationship-role> <ejb-relationship-role> <ejb-relationship-role-name>Book</ejb-relationship-role-name> <key-fields/> </ejb-relationship-role> </ejb-relation> </relationships> </jbosscmp-jdbc>