Hibernate Community • View topic - Expression.eq( ... usage for case insesitive

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Expression.eq( ... usage for case insesitive

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

rajukriss

Post subject: Expression.eq( ... usage for case insesitive

Posted: Mon Feb 06, 2006 4:07 pm

Newbie

Joined: Mon Feb 06, 2006 4:00 pm
Posts: 5

Hi,

I am trying to use Expression.eq in Criteria. I don't find any option that using for case insesitive for "equal" operation in API.

Can anyone suggest on this.

Thanks
Raju.M

Top

tenwit

Post subject:

Posted: Mon Feb 06, 2006 4:16 pm

Expert

Joined: Thu Dec 23, 2004 9:08 pm
Posts: 2008

I don't konw of any databases that allow for case-insensitive comparisons. The ref docs have exactly what you're looking for in section 15.2:

Code:

List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.sqlRestriction("lower({alias}.name) like lower(?)", "Fritz%", Hibernate.STRING) )
    .list();

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum