dynamic mapped statements

ta · **Joined:** Wed Jun 30, 2004 12:37 pm **Posts:** 9

Hi,
I am a new Hibernate user and I was really impressed by the available features. However, I would like to know whether Hibernate contains something like dynamic mapped statements of iBatis. If it dosen't, what's the best way to generate queries for search forms where not all the fields are required ?
Thanks in advance.

christian · **Posted:** Wed Jun 30, 2004 1:08 pm

We use Query By Criteria and Query By Example, see the documentation and API of Session.

baliukas · **Posted:** Thu Jul 01, 2004 1:23 am

Most of queries you can implement as static too. There is no problems in optional parameters, but query optimizer can fail to find good plan with this trick:

Code:

... ( firstName = ? OR ? IS NULL) AND ( lastName = ? OR ? IS NULL ) ...