Looking to migrate from Hibernate 5.X to 6.1. I have a custom Dialect where I register a number of functions in the constructor: e.g registerFunction(“ecfts”, new PgFullTextSearchFunction()); This approach is no longer supported. From what I can find, it looks like I will need to implement some…

@beikov I ended up switching paths a little and using your pattern function idea. I can give the gory details of why i switched if curious. Documentation for the next person trying to solve user defined functions in Hibernate. Here is my final class to register my two full text search functions: …

Ok, I have now read that thread. They are not registering an actual user defined function, and they are not manipulating the generated SQL to call and utilize a user defined function in the database. All they are doing is registering known functions of the database and changing return types. Howeve…

@beikov I believe I found your code in org.hibernate.dialect.function.SqlFunction I think this will likely be a good starting point. I still need to back trace the code enough to understand enough to implement my own function. I did not dig yet into the META-INF/services/org.hibernate.boot.model.F…

Yes, registering functions should happens through the FunctionContributor. Note that when the function return type is Boolean, you can use it as predicate directly i.e. in HQL where matches(...). You can render the fragment in a custom implementation, or you register a pattern function: functionCo…

I looked at the registerPattern actually. It does not work since I need to remove accents, and other special characters which break the PostgreSQL text search functions. I know I am missing something trying to back trace the code since my FunctionContributor does not work. With the many levels of i…

Maybe you should use the replace SQL function to let PostgreSQL do this? Otherwise your implementation only works if you pass literals. functionContributions.getFunctionRegistry().registerPattern( "myFunction", "to_tsvector(?1) @@ websearch_to_tsquery(unaccent(replace(regexp_replace(?2,'\\…

lol, I did not consider the PostgreSQL unaccent function. Hibernate starts now, and does not complain. However I cannot test yet, since I ran into a totally separate issue with my SpringBoot 3 upgrade. I will report back, after I get the other items resolved.

@tspear @beikov could you please share the github repo link for the complete working of the code. PS : do i need resiter PgFunctionContributor class in application.properties file?

It’s a Java ServiceLoader contract, so read here about how to enabled this: ServiceLoader (Java SE 9 & JDK 9 )

User Defined Functions in Dialect

Hibernate ORM

beikov November 29, 2022, 7:14am 2

I just recently answered a similar question: Migration of dialect to Hibernate 6

Topic		Replies	Views
Migration from SQLFunctionTemplate in FunctionContributor Hibernate ORM	9	2251	May 14, 2024
Migration of dialect to Hibernate 6 Hibernate ORM	29	25551	October 26, 2023
Custom function in Hibernate 6.x from 5.3 Hibernate ORM	2	2099	July 25, 2023
PostgresPlusDialect SQL functions in version 5.6 vs version 6.1 Hibernate ORM	6	1407	February 2, 2023
Register FunctionContributor programmatically Hibernate ORM	2	685	March 5, 2025

User Defined Functions in Dialect

Related topics