Bugs item #760165, was opened at 2003-06-24 23:57
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=760165&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: louis (l7leungsun)
Assigned to: Nobody/Anonymous (nobody)
Summary: CMR w/ incorrect sql
Initial Comment:
My application has a 1 to many CMR (i.e. one being a
purchase order ,
and many being line items). I don't think i've specified
the column
mapping for this relationship wrong. JBoss should be
firing "Select
MASTERORDER ..." sql when retreiving info about this
relation. But
instead, it fired "Select MASTERORDER_ORDERID ...". I
have no idea why
did it appended the _ORDERID at the end. Here is a
snippet of the
relation mapping xml in jbosscmp-jdbc.xml:
<!-- Relationships -->
<relationships>
<ejb-relation>
<ejb-relation-name>PurchaseOrderBean-lineItems-
masterOrder-LineItemBean</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>PurchaseOrderBean-
lineItems-LineItemBean</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>orderId</field-name>
<column-
name>MASTERORDER</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>LineItemBean-masterOrder-
PurchaseOrderBean</ejb-relationship-role-name>
</ejb-relationship-role>
</ejb-relation>
</relationships>
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=760165&group_id=22866
-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
