spring-data-jpa @Query support regex syntax?

Question

I'm now using spring data jpa to connect MySQL Server, how to use @Query to set regex search?

@Query(value = "select t from Tenants t where t.id regexp ?1")
Page regexSearch(String text, Pageable pageable);

My code not work, the error is "Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: regexp near line 1, column 72 [select t from com.sg.beans.Tenants t where t.id regexp ?1]", does anyone know how to write for regex search?

Oliver Drotbohm · Accepted Answer · 2014-05-20 07:06:20Z

5

JPQL does not support the regex function. You need to fall back to native SQL (using the nativeQuery flag on the @Query annotation).

answered May 20, 2014 at 7:06

Oliver Drotbohm

83.6k19 gold badges236 silver badges219 bronze badges

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

5 Comments

Awakening Over a year ago

I don't find the @NativeQuery Class, Could you tell in which spring package?

Oliver Drotbohm Over a year ago

There's no @NativeQuery class. As indicated in my answer, set the boolean flag nativeQuery in the @Query annotation to true to be able to use native SQL in your query declaration.

Oliver Drotbohm Over a year ago

That's got nothing to do with Spring. We forward the declared query as is. If you gained further insights, saw other exceptions it's helpful to add them to the question. "Doesn't work" doesn't really help investigating the problem :).

jvmvik Over a year ago

So, why the exception is origniated by Spring ? How to get to the root of this exception?org.springframework.dao.InvalidDataAccessApiUsageException: Unsupported keyword REGEX; nested exception is java.lang.IllegalArgumentException: Unsupported keyword REGEX.

Oliver Drotbohm Over a year ago

@jvmvik - Read up on that in the reference documentation.

Collectives™ on Stack Overflow

spring-data-jpa @Query support regex syntax?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related