Seemingly simple EJB-QL question

[Greg Charles]

I need to retrieve a single record matching two fields, call them jib and jab. The query is easy enough:

    
<query>
  <query-method>
      <method-name>findMatchingRecord</method-name>
      <method-params>
<method-param>java.lang.Integer</method-param>
        <method-param>java.lang.Integer</method-param>
      </method-params>
  </query-method>
  <ejb-ql>SELECT OBJECT(o) from MyTable o
          WHERE o.jib = ?1 AND o.jab = ?2
  </ejb-ql>
</query>

I know there will only be a single record, because I have a unique key constraint on jib and jab. However, jab can be null, and equality comparison doesn't work with nulls. I tried something like:

    WHERE (o.jib = ?1 AND o.jab = ?2) OR (o.jib = ?1 AND o.jab IS NULL AND ?2 IS NULL)

Checking parameters with "IS NULL" apparently doesn't work though, even though it works in ordinary SQL. The only solution I can think of is to write two queries and force the application to decide which one to use. I'd appreciate any suggestions!

We're using BEA WebLogic 8.1 and Oracle 9i.