Hi!
I want to use a named query to get the results for the user's search page. However, i only need to insert 'where constraints' for the fields that have been filled in with values.
So here are my questions:
- does the 'namedQuery.setParameter("fieldName", null)' ignore this constraint for any relational database?
- is it possible to remove a where constraint (e.g. 'where name = :name') out of the query object before executing the query?

Any comments are greatly appreciated!
Thanks in advance,
Christian

No, you could not do it using named queries. Use Criteria API instead.

valeuz...

thanks a lot,
regards!

can I use queries involving joining of multiple tables if I use Criteria API?

yes. read the docs.

thanks for the reply. I'm just reading "hibernate in action".

i've a complex oracle sql query joins multiple tables..
need to use oracle hints for performance boosting. So thought of using native sqls.
But want to externalise using named queries.

the query is pretty dynamic also. need to change the "where" conditions dynamically.

I think I can't acheive this in hibernate. (am I right?)

Is there any java api where I can express my sql queries in xml?

Maybe just put the queries (or where clauses if these are all that vary) in xml CDATA sections? IIRC the OReilly developer notebook "Harnessing Hibernate" has examples like this.

Could you pls put an exmple here, as i dont have that book "Harnessing Hibernate"?

Thanks a lot.