Hi,

Is correct this query:

<query>
    <query-method>
        <method-name>findOpen</method-name>
        <method-params />
    </query-method>
    <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(c) FROM Call AS c, IN (c.voice)
AS v WHERE v.date IS NULL]]></ejb-ql>
</query>

I don't understand why JBoss 3.0 translate this query in:

2002-02-07 22:01:07,957 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ChiamataEJB.findOpene] SQL:
SELECT DISTINCT t1_c.Id FROM CallEJB t1_c, VoiceEJB t2_v WHERE
t1_c.Id=t2_v.call

Where is date='null'?

Thank
Michele


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to