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...
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
Which doesn't return anything because the id-field of the
merchantPartnerContract is the PK-field and therefore never
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,
thanks for your help, it works!
Is the SQL92 Compiler scheduled to become the
default compiler for the JBoss 3.x series?
The wiki page explains why it is not the default one. This is our testsuite problem.