Regex Queries without using Native SQL queries - JPA

Question

My question is how to get values from the database (PostgreSQL) by regex, BUT not using native SQL queries. The only way I found is to use Hibernate Criteria API:

criteria.add(Restrictions.sqlRestriction("name ~ '^(?!" + filter + ")'"));

But this method also uses SQL. Spring data has query creation functionality but regex search seems to be working only with MongoDb.

http://docs.spring.io/spring-data/jpa/docs/current/reference/html/#repository-query-keywords

My goal is not depending on native sql queries, use objects instead, and make my project portable for any other databases.

JPA is doing O-R mapping. Your queries have to finally be turned into SQL to be executed in the DBMS. Forget about JPA, ask yourself: how can you retrieve data from PostGres without using SQL and is "portable"? I don't believe you can do it. — Adrian Shum
– Adrian Shum, Commented Dec 29, 2016 at 8:26
It is clear that hibernate, spring data and others will use sql queries eventually and there is no other way. I am looking for the functions of these like: someObject.addRegex(String regex). — Igor Orekhov
– Igor Orekhov, Commented Dec 29, 2016 at 10:35
someObject.addRegex(String regex) means nothing. What you are looking for is not archievable: There is no portable that you can query data from different DBMS without SQL — Adrian Shum
– Adrian Shum, Commented Dec 29, 2016 at 10:37
Please, have a look: docs.spring.io/spring-data/jpa/docs/current/reference/html/… docs.spring.io/spring-data/jpa/docs/current/reference/html/… — Igor Orekhov
– Igor Orekhov, Commented Dec 29, 2016 at 10:39
so?... what you have quoted has nothing to do with your question — Adrian Shum
– Adrian Shum, Commented Dec 29, 2016 at 10:41

Emin Javadov · Accepted Answer · 2016-12-29 10:37:52Z

2

You can do it with extending Hibernate Dialect class(es) and add your custom methods. Magic really ? :)

answered Dec 29, 2016 at 10:37

Emin Javadov

1401 silver badge8 bronze badges

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

1 Comment

Emin Javadov Over a year ago

UPDATE : If you are using Spring MVC and you want to get only matches from url params then you can use regex pattern within RequestMapping. for example : @RequestMapping(value = "/e{^\\+?\\d+\$}")

Collectives™ on Stack Overflow

Regex Queries without using Native SQL queries - JPA

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related