Hi there,

I'm from iBatis background and recently started exploring Hibernate. My task is to convert ORMapping layer from iBatis to Hibernate. Simple queries presented in iBatis sql map can easily be converted as per hibernate sql syntax. But I couldnt find a way to represent below query in hibernate format.

this is a search query which is dynamically formed at runtime based on search criteria specified. What alternative do we have in hibernate to represent <isNotEmpty/> kinda functionality? How would I write the below query in hibernate syntax?

<select id="search" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
select CustomerNumber, Name, RXVolume, City, State, Phone, email from Customer
<dynamic prepend=" where ">
<isNotEmpty property="CustomerNumber" prepend=" and ">CustomerNumber like #CustomerNumber# + '%'</isNotEmpty>
<isNotEmpty property="Name" prepend=" and ">Name like #Name# + '%'</isNotEmpty>
<isNotEmpty property="RXVolume" prepend=" and ">RXVolume like #RXVolume# + '%'</isNotEmpty>
<isNotEmpty property="State" prepend=" and ">State like #State# + '%'</isNotEmpty>
</dynamic>
</select>


Thanks in advance.. I'd really appreciate your help in this.

Regards
Nilesh

Use a Criteria query.

Thanks gavin.

Criteria query seems to be a good option... My only hesitation is now I'd have to write java code to form SQL queries. I can try to write a generic program which will parse thro XML and then form Criteria query accordingly.

It would be really cool if hibernate can provide a way to embedd criteria query in XML or HQL format. This will avoid plenty of coding + all sql queries can be maintained in a seperate repository.

Well, thanks again, gavin.

~ Nilesh