Bugs item #576370, was opened at 2002-07-02 15:38
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=576370&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Jacek Bialecki (jacekb)
Assigned to: Nobody/Anonymous (nobody)
Summary: EJB-QL compiler generates corrupted SQL
Initial Comment:
I'm trying to deploy my app on JBoss 3.0.1 RC1 and this
version can't interpret correctly my ejb-ql queries (JBoss
3.0.0 worked fine! )
Example:
EJB-QL:
SELECT aj.akcja FROM DokODBean d,
IN(d.role) r,
IN(r.typRoli.akcje) aj
WHERE d = ?1 AND
r.uzytk = ?2 AND
d.typDok.id = aj.typDokId AND
r.poziom = ?3 AND
aj.akcja.groupNum = ?4
AND r.aktywna <> 0
JBoss 3.0.1RC1 generated SQL (corrupted, Oracle
returns error):
SELECT
DISTINCT t0_aj_akcja.id
FROM
DOK_OD t1_d,
ROLA t5_r,
AKCJA_TYP_ROLI t4_aj,
AKCJA t0_aj_akcja,
TYP_DOK t3_d_typDok,
UZYTK t2_r_uzytk
WHERE
((t1_d.id=?) AND
(t2_r_uzytk.id=?) AND
t3_d_typDok.id = t4_aj.typ_dok_id AND
t5_r.poziom = ? AND
t0_aj_akcja.group_num = ? AND
t5_r.aktywna <> 0) AND
(t4_aj.id_akcja=t0_aj_akcja.id AND
t1_d.typ_dok_id=t3_d_typDok.id AND
t5_r.id_uzytk=t2_r_uzytk.id AND
t11_r_typRoli.id=t4_aj.id_typ_roli AND
t5_r.id_typ_roli=t11_r_typRoli.id AND
t1_d.id=t5_r.id_dok)
(there is no join to TYP_ROLI table)
JBoss 3.0.0 generated SQL (this is correct):
SELECT
DISTINCT t0_aj_akcja.id
FROM
DOK_OD t1_d,
ROLA t5_r,
AKCJA_TYP_ROLI t4_aj,
UZYTK t2_r_uzytk,
TYP_ROLI t6_r_typRoli,
TYP_DOK t3_d_typDok,
AKCJA t0_aj_akcja
WHERE
((t1_d.id=?) AND
(t2_r_uzytk.id=?) AND
t3_d_typDok.id = t4_aj.typ_dok_id AND
t5_r.poziom = ? AND
t0_aj_akcja.group_num = ? AND
t5_r.aktywna <> 0) AND
(t1_d.id=t5_r.id_dok AND
t5_r.id_uzytk=t2_r_uzytk.id AND
t5_r.id_typ_roli=t6_r_typRoli.id AND
t6_r_typRoli.id=t4_aj.id_typ_roli AND
t1_d.typ_dok_id=t3_d_typDok.id AND
t4_aj.id_akcja=t0_aj_akcja.id)
OS: WindowsNT 4.0 SP6
Java: 1.3.1
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=576370&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
