[Xdoclet-user] Strange no generated for weblogic-cmp-rdbms.xml ???

[Eric Chow]

Hello,

It's very strange that can't generate Many-to-Many CMR <foreign-key-column>
for WebLogic.

But it just occured in one case not all. Please check my
sources(UserRoleBean.java, UserGroupBean.java, and the
weblogic-cmp-rdbms.xml) in the attachments.


weblogic-cmp-rdbms.xml ---> line 1448.

Best regards,
Eric


==========================
If you know what you are doing, 
it is not called RESEARCH!
==========================
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE weblogic-rdbms-jar PUBLIC "-//BEA Systems, Inc.//DTD WebLogic 7.0.0 EJB RDBMS Persistence//EN" "http://www.bea.com/servers/wls700/dtd/weblogic-rdbms20-persistence-700.dtd";>

<weblogic-rdbms-jar>
   <weblogic-rdbms-bean>
      <ejb-name>Shipment</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_shipment</table-name>
      <field-map>
         <cmp-field>shipmentNo</cmp-field>
         <dbms-column>shipmentNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>shipmentMethod</cmp-field>
         <dbms-column>shipmentMethod</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>shipmentOption</cmp-field>
         <dbms-column>shipmentOption</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>shipmentDate</cmp-field>
         <dbms-column>shipmentDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address1</cmp-field>
         <dbms-column>address1</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address2</cmp-field>
         <dbms-column>address2</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address3</cmp-field>
         <dbms-column>address3</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>city</cmp-field>
         <dbms-column>city</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>province</cmp-field>
         <dbms-column>province</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>country</cmp-field>
         <dbms-column>country</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Shipment AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.ShipmentPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>AccountRecord</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_accountRecord</table-name>
      <field-map>
         <cmp-field>recordNo</cmp-field>
         <dbms-column>recordNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>recordDate</cmp-field>
         <dbms-column>recordDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>amount</cmp-field>
         <dbms-column>amount</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.AccountRecordPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a WHERE a.recordDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a WHERE a.recordDate < ?1 or a.recordDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a WHERE a.recordDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a WHERE a.recordDate >?1 or a.recordDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM AccountRecord AS a WHERE a.recordDate > ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>UserInfo</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_userinfo</table-name>
      <field-map>
         <cmp-field>userInfoId</cmp-field>
         <dbms-column>userInfoId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>firstName</cmp-field>
         <dbms-column>firstName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>lastName</cmp-field>
         <dbms-column>lastName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>pid</cmp-field>
         <dbms-column>pid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>sex</cmp-field>
         <dbms-column>sex</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>birth</cmp-field>
         <dbms-column>birth</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>email</cmp-field>
         <dbms-column>email</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>phone</cmp-field>
         <dbms-column>phone</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address1</cmp-field>
         <dbms-column>address1</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address2</cmp-field>
         <dbms-column>address2</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address3</cmp-field>
         <dbms-column>address3</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>city</cmp-field>
         <dbms-column>city</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>province</cmp-field>
         <dbms-column>province</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>country</cmp-field>
         <dbms-column>country</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>timeZoneId</cmp-field>
         <dbms-column>timeZoneId</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM UserInfo AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.UserInfoPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Account</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_account</table-name>
      <field-map>
         <cmp-field>accountNo</cmp-field>
         <dbms-column>accountNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>accountType</cmp-field>
         <dbms-column>accountType</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>currency</cmp-field>
         <dbms-column>currency</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>balance</cmp-field>
         <dbms-column>balance</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>createDate</cmp-field>
         <dbms-column>createDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>updateDate</cmp-field>
         <dbms-column>updateDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.AccountPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.createDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.createDate < ?1 or a.createDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.createDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.createDate >?1 or a.createDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.createDate > ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.updateDate < ?1 or a.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.updateDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.updateDate > ?1 or a.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Account AS a WHERE a.updateDate > ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>UserGroup</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_userGroup</table-name>
      <field-map>
         <cmp-field>groupId</cmp-field>
         <dbms-column>groupId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>name</cmp-field>
         <dbms-column>name</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM UserGroup AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.UserGroupPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(g) FROM UserGroup AS g WHERE g.name = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>UserSecret</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_userSecret</table-name>
      <field-map>
         <cmp-field>secretId</cmp-field>
         <dbms-column>secretId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>secretKey</cmp-field>
         <dbms-column>secretKey</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>passwords</cmp-field>
         <dbms-column>passwords</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>pin</cmp-field>
         <dbms-column>pin</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>isPlainKey</cmp-field>
         <dbms-column>isPlainKey</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM UserSecret AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.UserSecretPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Payment</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_payment</table-name>
      <field-map>
         <cmp-field>paymentNo</cmp-field>
         <dbms-column>paymentNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>paymentMethod</cmp-field>
         <dbms-column>paymentMethod</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>accountNo</cmp-field>
         <dbms-column>accountNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>expireDate</cmp-field>
         <dbms-column>expireDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Payment AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.PaymentPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Counter</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_counter</table-name>
      <field-map>
         <cmp-field>name</cmp-field>
         <dbms-column>name</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>currentId</cmp-field>
         <dbms-column>currentid</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Counter AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.CounterPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Counter AS a WHERE a.name = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>ItemCategory</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_itemCategory</table-name>
      <field-map>
         <cmp-field>categoryId</cmp-field>
         <dbms-column>categoryId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>categoryName</cmp-field>
         <dbms-column>categoryName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.ItemCategoryPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM ItemCategory AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCategoryName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(c) FROM ItemCategory AS c WHERE c.categoryName = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Item</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_item</table-name>
      <field-map>
         <cmp-field>itemNo</cmp-field>
         <dbms-column>itemNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>itemName</cmp-field>
         <dbms-column>itemName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>price</cmp-field>
         <dbms-column>price</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>photo</cmp-field>
         <dbms-column>photo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Item AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.ItemPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByItemName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.itemName = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrice</method-name>
            <method-params>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPriceRange</method-name>
            <method-params>
               <method-param>double</method-param>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price BETWEEN ?1 AND ?2]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPriceLT</method-name>
            <method-params>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPriceGT</method-name>
            <method-params>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price > ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPriceLE</method-name>
            <method-params>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price < ?1 OR i.price = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPriceGE</method-name>
            <method-params>
               <method-param>double</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.price > ?1 OR i.price = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByItemType</method-name>
            <method-params>
               <method-param>eric.share.interfaces.ItemType</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Item AS i WHERE i.itemType = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>CdItem</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_cdItem</table-name>
      <field-map>
         <cmp-field>itemNo</cmp-field>
         <dbms-column>itemNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>singer</cmp-field>
         <dbms-column>singer</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>totalDisc</cmp-field>
         <dbms-column>totalDisc</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM CdItem AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.CdItemPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Song</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_song</table-name>
      <field-map>
         <cmp-field>songNo</cmp-field>
         <dbms-column>songNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>songName</cmp-field>
         <dbms-column>songName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>duration</cmp-field>
         <dbms-column>duration</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>singer</cmp-field>
         <dbms-column>singer</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>discNo</cmp-field>
         <dbms-column>discNo</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Song AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.SongPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findBySongName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM Song AS i WHERE i.songName = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>UserRole</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_userRole</table-name>
      <field-map>
         <cmp-field>roleId</cmp-field>
         <dbms-column>roleId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>roleName</cmp-field>
         <dbms-column>roleName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM UserRole AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.UserRolePK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByRoleName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM UserRole AS a WHERE a.roleName = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Invoice</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_invoice</table-name>
      <field-map>
         <cmp-field>invoiceNo</cmp-field>
         <dbms-column>invoiceNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>invoiceDate</cmp-field>
         <dbms-column>invoiceDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>amount</cmp-field>
         <dbms-column>amount</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Invoice AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.InvoicePK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>ItemType</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_itemType</table-name>
      <field-map>
         <cmp-field>typeNo</cmp-field>
         <dbms-column>typeNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>typeName</cmp-field>
         <dbms-column>typeName</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM ItemType AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.ItemTypePK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByTypeName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(t) FROM ItemType AS t WHERE t.typeName = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>BookItem</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_bookItem</table-name>
      <field-map>
         <cmp-field>itemNo</cmp-field>
         <dbms-column>itemNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>isbn</cmp-field>
         <dbms-column>isbn</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>edition</cmp-field>
         <dbms-column>edition</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>author</cmp-field>
         <dbms-column>author</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>publisher</cmp-field>
         <dbms-column>publisher</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM BookItem AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.BookItemPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByIsbn</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(i) FROM BookItem AS i WHERE i.isbn = ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Order</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_order</table-name>
      <field-map>
         <cmp-field>orderNo</cmp-field>
         <dbms-column>orderNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>orderDate</cmp-field>
         <dbms-column>orderDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>amount</cmp-field>
         <dbms-column>amount</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Order AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.OrderPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>User</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_user</table-name>
      <field-map>
         <cmp-field>userId</cmp-field>
         <dbms-column>userId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>status</cmp-field>
         <dbms-column>status</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>createDate</cmp-field>
         <dbms-column>createDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>updateDate</cmp-field>
         <dbms-column>updateDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>expireDate</cmp-field>
         <dbms-column>expireDate</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM User AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.UserPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.createDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.createDate < ?1 or u.createDate= ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.createDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.createDate > ?1 or u.createDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByCreateDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.createDate > ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.updateDate < ?1 or u.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.updateDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.updateDate > ?1 or u.updateDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByUpdateDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.updateDate > ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByExpireDate</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.expireDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByExpireDate_LE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.expireDate < ?1 or u.expireDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByExpireDate_LT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.expireDate < ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByExpireDate_GE</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.expireDate > ?1 or u.expireDate = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByExpireDate_GT</method-name>
            <method-params>
               <method-param>java.util.Date</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(u) FROM User AS u WHERE u.expireDate > ?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Address</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_address</table-name>
      <field-map>
         <cmp-field>addressId</cmp-field>
         <dbms-column>addressId</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>street1</cmp-field>
         <dbms-column>street1</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>street2</cmp-field>
         <dbms-column>street2</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>street3</cmp-field>
         <dbms-column>street3</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>city</cmp-field>
         <dbms-column>city</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>province</cmp-field>
         <dbms-column>province</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>country</cmp-field>
         <dbms-column>country</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>phone</cmp-field>
         <dbms-column>phone</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>fax</cmp-field>
         <dbms-column>fax</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>mobile</cmp-field>
         <dbms-column>mobile</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>email</cmp-field>
         <dbms-column>email</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM Address AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.AddressPK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>DBMessage</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_dbmessage</table-name>
      <field-map>
         <cmp-field>application</cmp-field>
         <dbms-column>application</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>key</cmp-field>
         <dbms-column>name</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>charset</cmp-field>
         <dbms-column>charset</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>message</cmp-field>
         <dbms-column>message</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM DBMessage AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.DBMessagePK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByKey</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM DBMessage AS a WHERE a.key = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByApplication</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM DBMessage AS a WHERE a.application = ?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByApplicationAndKey</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM DBMessage AS a WHERE a.application = ?1 AND a.key = ?2]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>OrderLine</ejb-name>
      <data-source-name>MacauSMSDS</data-source-name>
      <table-map>
      <table-name>chk_orderLine</table-name>
      <field-map>
         <cmp-field>orderLineNo</cmp-field>
         <dbms-column>orderLineNo</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>quantity</cmp-field>
         <dbms-column>quantity</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>price</cmp-field>
         <dbms-column>price</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>discount</cmp-field>
         <dbms-column>discount</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>discountType</cmp-field>
         <dbms-column>discountType</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>amount</cmp-field>
         <dbms-column>amount</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>description</dbms-column>
      </field-map>
      </table-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM OrderLine AS a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByPrimaryKey</method-name>
            <method-params>
               <method-param>eric.share.pk.OrderLinePK</method-param>
            </method-params>
         </query-method>
      </weblogic-query>

   </weblogic-rdbms-bean>

   <weblogic-rdbms-relation>
      <relation-name>orderLine-item</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>orderLine-has-item</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>itemNo</foreign-key-column>
            <key-column>orderLineNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>userGroup-userRole</relation-name>
      <table-name>chk_group_role_link</table-name>
      <weblogic-relationship-role>

         <relationship-role-name>userRole-belongs-to-userGroups</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column></foreign-key-column>
            <key-column>groupId</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
      <weblogic-relationship-role>
         <relationship-role-name>userGroup-has-userRoles</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column></foreign-key-column>
            <key-column>roleId</key-column>
         </column-map>
        </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>order-invoice</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>order-has-invoice</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>invoiceNo</foreign-key-column>
            <key-column>orderNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-userInfo</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>user-has-userinfo</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>userInfoId</foreign-key-column>
            <key-column>userId</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>order-orderLine</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>order-has-to-orderLines</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>orderLineNo</foreign-key-column>
            <key-column>orderNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-userSecret</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>user-has-userSecret</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>secretId</foreign-key-column>
            <key-column>userId</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-order</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>order-belongs-to-user</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>userId</foreign-key-column>
            <key-column>orderNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>cd-song</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>song-belongs-to-cd</relationship-role-name>
         <relationship-role-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>invoice-shipment</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>shipment-belongs-to-invoice</relationship-role-name>
         <relationship-role-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>invoice-payment</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>payment-belongs-to-invoice</relationship-role-name>
         <relationship-role-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-account</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>account-belongs-to-user</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>userId</foreign-key-column>
            <key-column>accountNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>account-accountRecord</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>accountRecord-belongs-to-account</relationship-role-name>
         <relationship-role-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>item-itemCategory</relation-name>
      <table-name>chk_item_itemCategory_link</table-name>
      <weblogic-relationship-role>

         <relationship-role-name>item-belongs-to-itemCategory</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>categoryId</foreign-key-column>
            <key-column>itemNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
      <weblogic-relationship-role>
         <relationship-role-name>itemCategory-has-items</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>itemNo</foreign-key-column>
            <key-column>categoryId</key-column>
         </column-map>
        </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-userGroup</relation-name>
      <table-name>chk_user_group_link</table-name>
      <weblogic-relationship-role>

         <relationship-role-name>user-belongs-to-userGroups</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>groupId</foreign-key-column>
            <key-column>userId</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
      <weblogic-relationship-role>
         <relationship-role-name>userGroup-belongs-to-users</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column></foreign-key-column>
            <key-column>userId</key-column>
         </column-map>
        </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>user-userRole</relation-name>
      <table-name>chk_user_role_link</table-name>
      <weblogic-relationship-role>

         <relationship-role-name>user-belongs-to-userRoles</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>roleId</foreign-key-column>
            <key-column>userId</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
      <weblogic-relationship-role>
         <relationship-role-name>userRole-has-users</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>userId</foreign-key-column>
            <key-column>roleId</key-column>
         </column-map>
        </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>
   <weblogic-rdbms-relation>
      <relation-name>item-itemType</relation-name>
      <weblogic-relationship-role>

         <relationship-role-name>item-belongs-to-itemType</relationship-role-name>
         <relationship-role-map>
         <column-map>
            <foreign-key-column>typeNo</foreign-key-column>
            <key-column>itemNo</key-column>
         </column-map>
         </relationship-role-map>
      </weblogic-relationship-role>
   </weblogic-rdbms-relation>

   <create-default-dbms-tables>True</create-default-dbms-tables>

</weblogic-rdbms-jar>

UserRoleBean.java
Description: Binary data

UserGroupBean.java
Description: Binary data