i'm having problem with passing null values to a finder
method. the generated SQL looks like this:
Executing SQL: SELECT t0_o.id FROM ORDER t0 WHERE t0_o.type = ?
i want to search for objects where the "type" is null
but when i pass a null value to the finder, it returns
0 records. i'm sure there are records with "type"
column null in the database. my question is, in SQL,
to search for null columns, don't we need to use the
"IS NULL" clause instead of "= NULL"? i don't believe
the above SQL will work for nulls.
> don't we need to use the "IS NULL" clause instead
> of "= NULL"?
Yes, so use IS NULL in you EJB-QL.