Can HQL generate SQL Contains statement

okwei · **Joined:** Fri Jul 16, 2010 2:43 pm **Posts:** 2

I'd like to use Contains() instead of LIKE to improve text searching performance, but I could not make HQL to generate the SQL contains statements, is there a way doing this? without using native SQL...

sanne.grinovero · **Posted:** Sun Jul 18, 2010 6:39 pm

did you look into Hibernate Search ? you might love it for this use case, especially if you're interested in performance, but there are other good reasons.

I don't think contains could be part of HQL, as I don't think that's implemented by many databases so it would be hard to support on all of them.

okwei · **Joined:** Fri Jul 16, 2010 2:43 pm **Posts:** 2

s.grinovero wrote:

did you look into Hibernate Search ? you might love it for this use case, especially if you're interested in performance, but there are other good reasons.

I don't think contains could be part of HQL, as I don't think that's implemented by many databases so it would be hard to support on all of them.

I know Hibernate Search, too bad I can't use it for the current project, stuck with Oracle text. I guess I got to build native SQL, instead of HQL.