Using Like for pattern matching in HQL

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Hi

I am new to hibernates.

I am using hibernates HQL like statement to get the data from the database. Here is code :

getdetails=session.createQuery("select c from CommandBean as c where c.actionFunction like :var ");
getdetails.setString("var",actionFunction);

Suppose actionFunction pdommara , then it will return list of data.

But when actionFunction is like %pdom%( String str="%"+actionFunction+"%";) , it is not returning any list of values.

Pls any one can help me !!

Thanks In Advance
Praveen.

guymahieu · **Joined:** Sat Sep 09, 2006 5:55 am **Posts:** 23

pdommara wrote:

getdetails=session.createQuery("select c from CommandBean as c where c.actionFunction like :var ");
getdetails.setString("var",actionFunction);

Strange, that should work, this is how we do it:

Code:

 
queryString.Append(fieldName + " LIKE " + ":" + key)
// ...
getdetails.setParameter(key, "%" + fieldValue + "%");

I'm not sure why this would act different from your code, but it seems to work ok overhere.

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Hi guymahieu,

It worked !!

Thanks for Reply !!

Thanks A lot !!

But wants to know what is diffrence in between :

str="%"+actionFuncation+"%";

query.setString("key",str);
and
query.setString("key","%"+actionFuncation+"%");

pls reply me !!

Praveen.

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Hi guymahieu,

It worked !!

Thanks for Reply !!

Thanks A lot !!

But wants to know what is diffrence in between :

str="%"+actionFuncation+"%";

query.setString("key",str);
and
query.setString("key","%"+actionFuncation+"%");

pls reply me !!

Praveen

guymahieu · **Joined:** Sat Sep 09, 2006 5:55 am **Posts:** 23

pdommara wrote:

But wants to know what is diffrence in between :
str="%"+actionFuncation+"%";
query.setString("key",str);
and
query.setString("key","%"+actionFuncation+"%");

Hehe, nothing! So I guess it went wrong for another reason before. Good thing you have it working now though.

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Ok

Thanks For great Support !!

praveen.