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) ");

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
– OPTIMUS, Commented Mar 15, 2016 at 9:00

Community · Accepted Answer · 2017-05-23 12:15:28Z

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, 2017 at 12:15

CommunityBot

11 silver badge

answered Mar 15, 2016 at 13:23

Dragan Bozanovic

23.6k5 gold badges50 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jens · Accepted Answer · 2022-03-06 17:09:55Z

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 6, 2022 at 17:09

Jens

69.6k15 gold badges107 silver badges133 bronze badges

answered Mar 15, 2016 at 13:42

Amar Lal Bharti

12 bronze badges

1 Comment

OPTIMUS Over a year ago

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.

Collectives™ on Stack Overflow

Use regex query with hibernate in Spring

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related