Using Hibernate 3.0.

I have an SQL query in a hibernate mapping file. This has been serving me well up to now. I have now been asked to do the same query but with three optional parameters. At the moment the only approach I can think of is to write multiple queries for the different combinations of parameters, but this is neither elegant or easy to maintain. Another approach is to move the query into the Java code, but I want to avoid that, since we want to keep the query text separate from the Java code.

Does anyone know whether this is possible. If using HQL is the solution, then that is fine, but either way I am not sure how to go about it.

make a file with .properties extension
place ur all queries in this file. every query will be having some name, i can say that this will be like a key and value pair. name in left of = sign will be key and at right, query will be.
Now use object of java.util.Property class in ur java class and access the query with its key name using this object. In case of any further problem, let me know.

Thanks,
Gopal
[please rate, if helpful]

Thanks for the answer. How is this different than using the mapping (hbm) file? I am not sure it solves the problem I have.

try this first. I am already done.

I've done optional parameters in a single SQL query before. I just used a part of the WHERE clause like this:
The only problem was that Hibernate needed the type specified when null was passed. So I had to do this:

instead of the usual:

In my case I don't need to query for null, so I use it to indicate not to check for the value. If you do need to query for null as well as other values then you could probably use two parameters. The first to indicate that the second should be checked for.

Lance,

I did not realize it could be done that way. Thank you! I may use that myself.