EJB-QL CMR traversal returns wrong interface type
-------------------------------------------------

         Key: JBAS-1296
         URL: http://jira.jboss.com/jira/browse/JBAS-1296
     Project: JBoss Application Server
        Type: Bug
  Components: CMP service, EJBs  
    Versions: JBossAS-4.0.1 Final, JBossAS-4.0.0 Final    
 Environment: Windows XP with JBoss 4.0.0 and JBoss 4.0.1
Xdoclet, Eclipse 3.1
    Reporter: Wilson Pu
 Assigned to: Scott M Stark 
    Priority: Critical


// Same bug posted on SourceForge with attachment
Hello,
JBOSS App. Srv. returns/contains wrong interface type with CMR traversal using 
EJB-QL.  We recreated the line item example from Mastering EJB Appendix D on 
EJB-QL entity bean relationship traversal (page 574).

Test case below. 

We created 3 tables:

Customer
---------
customerId (pk)
name

Order
---------
orderId (pk)
customerId (fk)
date

LineItem
---------
lineItemId (pk)
orderId (fk)
sku
quantity

On the CustomerBean, we defined a finder method using Xdoclet.

@ejb.finder
signature="Collection
findCustomerLineItems(int customerId)"
unchcked="true"
query="SELECT OBJECT(l) FROM Customer AS c,
IN(c.orders) o, IN (o.lineItems) l WHERE c.customerId=?1"
result-type-mapping="Local"

We also defined CMR for getting the orders from the customer bean and getting 
the lineitems from the order bean. 

Base on the finder method, we are expecting to return a collection of 
LineItemLocal interface. However, we got CustomerLocal interface instead.



Wilson Pu
[EMAIL PROTECTED]
Software Developer
Vision Solutions Inc.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira



-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to