-
1. Re: EJB Select not working
stscit04 Dec 16, 2004 1:25 PM (in response to stscit04)I set logging to debug and the generated SQL is
Executing SQL: SELECT DISTINCT t0_m.id FROM Merchant t0_m WHERE (t1_m_merchantPartnerContract.id IS NULL)
which doesn't look ok to me...
Regards
Stefan -
-
3. Re: EJB Select not working
stscit04 Dec 20, 2004 9:14 AM (in response to stscit04)I tried 3.2.6 and the Exception disappeared. But the query still gives
incorrect results (or at least unexpected results, maybe I am thinking
in the wrong way)
The SQL executed under 3.2.6 is:
SELECT DISTINCT t0_m.id FROM Merchant t0_m, MerchantPartnerContract t1_m_merchantPartnerContract WHERE
(t1_m_merchantPartnerContract.id IS NULL AND
t0_m.id=t1_m_merchantPartnerContract.merchantId)
Which doesn't return anything because the id-field of the
merchantPartnerContract is the PK-field and therefore never
NULL.
The query should retun the merchant.id field for all
merchants that don't have a contract (and therefore dont
show up in the merchantParnterContract.merchantId column).
Please let me know how to formulate a EJB QL query that
returns the desired results. Or maybe this IS a bug?
Thanks in advance,
Stefan -
4. Re: EJB Select not working
aloubyansky Dec 21, 2004 3:35 AM (in response to stscit04)Looks like a bug. Try sql92 query compiler
http://www.jboss.org/wiki/Wiki.jsp?page=PlugableQlCompiler -
5. Re: EJB Select not working
stscit04 Dec 21, 2004 8:12 AM (in response to stscit04)Hi,
thanks for your help, it works!
Is the SQL92 Compiler scheduled to become the
default compiler for the JBoss 3.x series?
Regards
Stefan -
6. Re: EJB Select not working
aloubyansky Dec 28, 2004 3:57 AM (in response to stscit04)The wiki page explains why it is not the default one. This is our testsuite problem.