native SQL set :parameter is null oder is not null

Psalidaki · **Joined:** Fri Apr 08, 2011 8:09 pm **Posts:** 2

hallo,

i have this HQL native SQL-Statement:

SELECT * FROM Tabelle
WHERE oe = :oe
AND druckdatum:druckdatum

my java query looks like this:

if(printID==1) {
query.setParameter("druckdatum", "is not null");
}
else {
query.setText("druckdatum", "is not null");
}

The value is null or is not null generate in the statement with quotes "is null" or "is no null". I need the value "is null" without quotes.

ngomo · **Joined:** Tue Sep 14, 2010 4:29 pm **Posts:** 16

Hallo Psalidaki,

is null or is not null cannot be set as parameters for queries. You'll have to write them as statements. E.g.

Code:

SELECT * FROM Tabelle
WHERE oe is not null
AND druckdatum:=druckdatum

If you want all possible combiantions, that means writing 4 separate SQL-Queries. If you want more flexibillity concerning your parameters, you should consider switching to Criteria-Queries.

Cheers ngomo