In EJBQL paths that appear in the FROM should be inner-joined. Other paths should be
outer-joined. Current compiler in 3.2 does not support outer joins and has some hucks
in this regards.
There is a new QL compiler in HEAD that is INNER/OUTER based. It might be ported to
3.2 one day.
http://www
Here's the DEBUG output:
Executing SQL:
| SELECT DISTINCT t0_rm.id
| FROM rolemodules t0_rm,
| userroles t12_ur,
| sessions t1_s,
| roles t5_rm_role,
| domains t2_rm_role_domain,
| modules t4_rm_module,
I am using JBoss 3.2.3. I'll report back when I have time to post the SQL.
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827797#3827797";>View
the original post
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827797>Reply
to the post
---
What version of JBoss are you using ? There was a problem with OR handing which (if I
remember correctly) was fixed in 3.2.3.
To make it easier to determine what the problem is, please enable DEBUG logging for
the org.jboss.ejb.plugins.cmp package. The SQL which is used will then be logged. Post
