Use regex query with hibernate in Spring

Question

I am able to fire query in query browser (my sql) and able to retrieve record like below SELECT * FROM details WHERE title REGEXP 'dem';

but when I use similar type of code in server side then I is giving error as unexpected token: REGEXP

After searching on web, it seems that hibernate does not support REGEXP. but some solution are also given which are not relevant to that. I need to handle this through query only in hibernate.

sbQuery.append("select distinct id from deatil id");
sbQuery.append("where ((id.title like :keyword) OR (id.description like :keyword) ");

Related : [Regex query in Hibernate](http://stackoverflow.com/q/5831768/4290096) — Arun Xavier, Mar 15 '16 at 08:19
Thanks for this, But for me this is not working because i need regex only. Workaround given i have already applied but these do not fulfilling my requirement else creating more issues. Any other way or suggestion — OPTIMUS, Mar 15 '16 at 09:00

score 0 · Answer 1 · edited May 23 '17 at 12:15

0

You could add your own custom function in the Hibernate dialect for your database.

I tried adding a custom function that was a bit more complex than this and I had issues to make it work, hopefully the simpler ones should work out of the box.

edited May 23 '17 at 12:15

Community

1
1

answered Mar 15 '16 at 13:23

Dragan Bozanovic

22,362
4
40
106

score 0 · Answer 2 · edited Mar 06 '22 at 17:09

0

    Query query = session.createSQLQuery("select distinct id from deatil id where (id.title like :keyword) OR (id.description like :keyword)")
.setParameter("keyword", keyword);
List result = query.list();

Missing ")" and must set parameter value.

edited Mar 06 '22 at 17:09

Jens

63,364
15
92
104

answered Mar 15 '16 at 13:42

Amar Lal Bharti

1
2

This will not be treated as regex. Ex I have a string "My ARG Students are good to pay for application and content" I want to search good and then i need to put like in loop condition. To avoid this i want to use regex. In short keyword parameter can contain many different keyword. – OPTIMUS Mar 16 '16 at 11:37

Use regex query with hibernate in Spring

2 Answers2