Regarding case insensitive Search

[shahzad.ahsan]

Hi,
i am using Hibernate3 with JPA using spring.
When i search the annotated entity in normal case. It worked fine and showed sql query in the log, with following code:

 list = this.getHibernateTemplate().findByExample(Example.create(iEntity));

but when i added ignorecase in the example, it did worked. Even i did not show SQL in the log.

Example example =	Example.create(iEntity).ignoreCase().enableLike(MatchMode.EXACT);
 list = this.getHibernateTemplate().findByExample(example);

Anyone help?

Regards,
shahzad

[shahzad.ahsan]

Example example = Example.create(iEntity).ignoreCase().enableLike(Ma tchMode.EXACT);

list = getSession()
.createCriteria(iEntity.getClass())
.add(example).list();

[silent.wong]

please using the Criteria class for your code!