How can you call custom database functions with Hibernate?

by

If you want to use your custom function in HQL, you’ll need to define it in appropriate Dialect

Take a look at PostgreSQLDialect (or any other, really) source, and you’ll see a bunch of registerFunction() calls. You’ll need to add one more 🙂 – for your own custom function.

You’ll then have to specify your own dialect in Hibernate configuration.

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. How do you do a limit query in JPQL or HQL?
  3. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  4. How to print a query string with parameter values when using Hibernate
  5. How to get SQL from Hibernate Criteria API (*not* for logging)
  6. JPA and Hibernate – Criteria vs. JPQL or HQL
  7. Hibernate Union alternatives
  8. Hibernate criteria: Joining table without a mapped association
  9. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  10. Hibernate Group by Criteria Object
  11. Hibernate Named Query Order By parameter
  12. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  13. How to prevent SQL Injection with JPA and Hibernate?
  14. How to escape reserved words in Hibernate’s HQL
  15. IN-clause in HQL or Java Persistence Query Language
  16. HQL Hibernate INNER JOIN
  17. HQL left join of un-related entities
  18. HQL – row identifier for pagination
  19. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  20. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  21. How to write a like query in HQL
  22. Hibernate Criteria API: get n random rows
  23. Get column name of property mapped with Hibernate
  24. HQL recursion, how do I do this?
  25. How to escape colon `:` within a native SQL query in Hibernate?
  26. Inserting data in one table using HQL in Hibernate
  27. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  28. Wrong ordering in generated table in jpa
  29. In which case do you use the JPA @JoinTable annotation?
  30. JPA Select latest instance for each item

Leave a Comment