Problem when using LikeExpression

bbtitia · **Joined:** Tue Jan 15, 2008 5:48 am **Posts:** 4

Hi,

I'm using hibernate 3.2.5.ga on Oracle 10.

I've a problem when I try to use LikeExpression :

I try two solutions which give the same SQL but not the same result :

my first solution :
Criteria crit =
session.createCriteria(MyObject.class).add(Restrictions.like("name", data + "%"));

my second (is for escape specialy character):
LikeExpression likeExp = new LikeExpression("name", data + "%");

Criteria crit =
session.createCriteria(MyObject.class).add((Criterion) likeExp));

In my BDD I have two objects with name begin by 'toto'. The first solution returns my two objects but the second not.

Have you any Ideas to help me.

Thanks

Cameron McKenzie · **Posted:** Wed Jun 25, 2008 3:20 pm

I always just like using the MatchMode:

Example example = Example.create(user);
example.enableLike(MatchMode.END);

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi

Code:

public static void main(String[] args) {
  User user = new User();
  user.setEmailAddress(".com");
  Example example = Example.create(user);
  example.enableLike(MatchMode.END);
  Session session = HibernateUtil.beginTransaction();
  Criteria criteria = session.createCriteria(User.class);
  criteria.add(example);  List results = criteria.list();
  for (int i = 0; i<results.size(); i++) {
    System.out.println(results.get(i).toString());
  }
  HibernateUtil.commitTransaction();
}

bbtitia · **Joined:** Tue Jan 15, 2008 5:48 am **Posts:** 4

Thank's a lot, it works

Cameron McKenzie · **Posted:** Thu Jun 26, 2008 9:32 am

Don't be afraid to rate the post. ;)