[ http://jira.jboss.com/jira/browse/JBAS-649?page=history ]
Scott M Stark closed JBAS-649:
------------------------------
Resolution: Out of Date
> JBoss-QL --> SQL conversion
> ---------------------------
>
> Key: JBAS-649
> URL: http://jira.jboss.com/jira/browse/JBAS-649
> Project: JBoss Application Server
> Type: Bug
> Components: CMP service
> Reporter: SourceForge User
> Assignee: Scott M Stark
>
>
> SourceForge Submitter: ytzel .
> - jboss3.0.6 (also testet with 3.2.0) with mysql 4.0.10
> - redhat8.0
> - jdk1.4.2
> given the following EJB-QL expression:
> SELECT DISTINCT OBJECT(ftx) FROM
> FinancialTransaction ftx, Subscription s
> WHERE s = ?1 AND (ftx.cycleChain MEMBER s.cycleChains
> OR ftx.feeForAction MEMBER s.feeForActions)
> results in SQL:
> SELECT DISTINCT t0_ftx.id, t0_ftx.state, t0_ftx.amount,
> t0_ftx.modifyDate FROM FinancialTransaction t0_ftx,
> Subscription t1_s LEFT JOIN CycleChain t2_s_cycleChains
> ON t1_s.id=t2_s_cycleChains.fk_subscription LEFT JOIN
> FeeForAction t4_s_feeForActions ON
> t1_s.id=t4_s_feeForActions.fk_subscription WHERE
> (t1_s.id=?) AND ((t2_s_cycleChains.id IS NOT NULL AND
> t2_s_cycleChains.id = t3_ftx_cycleChain.id) OR
> (t4_s_feeForActions.id IS NOT NULL AND
> t4_s_feeForActions.id = t5_ftx_feeForAction.id))
> as you can see, the table alias t3_ftx_cycleChain and
> alias t4_s_feeForActions will be used but is nowhere
> defined. so this results in a sql exception at runtime
> db-scheme: Bean A (FinancialTransaction) is related
> with B (CycleChain) XOR C (FeeForAction) in 1:1
> repectively, and B and C are related with Bean D in m:1
> i want to find a collection of Bean A with a given Bean D
--
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
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
