Hi-

Having a query with multiple parameters, I sometimes need to execute it with one of the parameters having a value of null. Other times, the parameter does have a value set.

Is there any way to accomplish this with a single query using setParameter?

It seems it could be accomplished with two different queries -- one using "is null" and the other using the setParameter approach, but that is a bit too messy.

Any help is appreciated.

Thanks

This is not supported by JDBC, hence not by Hibernate. It is a good case for using the Criteria API.

somebody should change the jdbc spec....

i'll give the criteria api a shot.

thnx

one quick Q...

why does the setParameter(parameter, object, hibernateType) method accept null? it accepts it, but obviously doesn't perform an "is null".

just curious.

thnx