newbie - dynamic queries

nathancoast · **Joined:** Sat Nov 13, 2004 6:03 am **Posts:** 3

Hi,

I'm currently evaluating hibernate for use on a number of projects. I've used ibatis before and notice a number of features are common. One feature I can't see in hibernate is dynamic where clauses.

Is it possible to modify the where clause of named queries based upon the properties of the object passed to the query.setProperties(fooBean) method?

Taking an example from an ibatis config...

Code:

<query name="............">
select appointment.id as id, appointment_reference_no,
..........
.........
............
<dynamic>
      <isNotEmpty prepend="AND" property="bookingNumber">
        booking_number like '%' || #bookingNumber# || '%'
      </isNotEmpty>
      <isNotEmpty prepend="AND" property="containerOperatorId">
        cont_operator_mapping.id=#containerOperatorId#
      </isNotEmpty>
</dynamic>
</query>

thanks
Nathan

anthony · **Posted:** Sat Nov 13, 2004 3:08 pm

hibernate and ibatis are not really the same.

do you know the query api? named parameters should do the job

nathancoast · **Joined:** Sat Nov 13, 2004 6:03 am **Posts:** 3

Hi Anthony,

yes I've seen the query api. Is your suggestion to define the query in a config file and then modify the where clause in java (using the api)? Or have I mis-understood you?

I'd prefer to have all of the sql (including dynamic where clauses) in one place i.e. a config file. Is this possible?

thanks
Nathan