Hibernate Regex

Question

I am trying to build an API which can search by HQL regex keywords,

EDITED: The best way to perform regex search in HQL is to use criteria, Restrictions.like() or Restrictions.ilike().

public static List<Object> createQueryAnd(Criteria cri,
        ArrayList<Parameters> list) {

    for (Parameters p : list) {
        String value = (String) p.value;
        if (value.contains("*")) {
            value = value.replace("*", "%");
        } else {
            value += "%";
        }
        Criterion c1 = Restrictions.ilike(p.property, value);
        cri.add(c1);

    }

    return cri.list();
}

Hope this helps someone

Y is this being voted down? was it a silly question?

Biggy_java2
– Biggy_java2

2013-01-09 20:07:09 +00:00
Commented Jan 9, 2013 at 20:07 — Biggy_java2
– Biggy_java2, Commented Jan 9, 2013 at 20:07
It helped me, thank you! Vote up for you =)

Dmitry
– Dmitry

2013-06-20 12:26:04 +00:00
Commented Jun 20, 2013 at 12:26 — Dmitry
– Dmitry, Commented Jun 20, 2013 at 12:26

Community · Accepted Answer · 2017-05-23 12:00:56Z

5

HQL does not have regular expressions. If you want to use database provider specific constructs for regular expression, Dialect should be modified. This question contains discussion about how to do that with Oracle database.

edited May 23, 2017 at 12:00

CommunityBot

11 silver badge

answered Jan 9, 2013 at 20:07

Mikko Maunu

42.3k11 gold badges143 silver badges142 bronze badges

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

4 Comments

Biggy_java2 Over a year ago

Is there any thing specific to postgres dialect?

Mikko Maunu Over a year ago

You have to depend on functions/operators available in PostgreSQL when extending HQL: postgresql.org/docs/9.2/static/functions-matching.html

Biggy_java2 Over a year ago

Thanks...Does this seem to work: SELECT * from table where regexp_matches(colname, 'lan*'); ?

Mikko Maunu Over a year ago

No. As said, there is no support for regular expressions in HQL and also not in Hibernate criteria queries. To make it work, you have to implement it (part of implementation being extending Dialect). Also your query seems to be rather SQL than HQL.

Collectives™ on Stack Overflow

Hibernate Regex

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related