does hibernate support regular expression pattern matching?

The LIKE operator is declared in the base hibernate abstract Dialect class. This is how hibernate know about it.

You can extend your hibernate dialect for example in the following way:

public class YourDialect extends MySQL8Dialect {

   public YourDialect(){
      registerFunction(
          "REGEXP_LIKE",
           new StandardSQLFunction( "REGEXP_LIKE", StandardBasicTypes.INTEGER )
      );
   }
}

Then declare this dialect in your hibernate config and then you will be able to use the REGEXP_LIKE function in hql queries.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top