Re: [eclipselink-users] named query + skip null parameters
I think you get no results because column = null is not valid, you'd
need to do column is null.
Anyway, I don't think a named query is the proper way to go about a
I'd either use the expression API or a dynamically build query.
On Fri, May 9, 2008 at 9:08 AM, Leon Derks <leon.derks@xxxxxxxxxx> wrote:
> Yes I tried executing the query with the null params, but then no results
> are returned.
> For example when productCategory is null, I want to get all items.
> So skipping the (where productCategory = :productCategory) part in my named
> There are three search params, with can all be null. So we have 8 different
> search situations.
> I can make 8 different queries, but this is to complex I think.
> Therefore I hoped there was I way to skip the null parts in a named query.
> How is this normally done?
> Tim Hollosy wrote:
>> Did you try setting them to null?
>> On Fri, May 9, 2008 at 4:08 AM, Leon Derks <leon.derks@xxxxxxxxxx> wrote:
>>> I have a named query with three parameters.
>>> These parameters are search parameters and can be null.
>>> When I don't set the parameter in my DAO I get the following error:
>>> argument productName not found in the list of parameters provided during
>>> query execution"
>>> Is there a way to ignore the null parameters in my named query and only
>>> the parameters that are not null?
>>> eclipselink-users mailing list
> eclipselink-users mailing list