休眠方言中用户定义的PostgreSQL函数会引发异常 [英] User defined PostgreSQL function in hibernate dialect throws exception

问题描述

是否可以注册用数据库&用扩展的休眠Postgres方言编写的内容如下?在HQL中使用此功能时，接收功能不存在.

Is it possible to register a custom function written in database & written in extended hibernate Postgres Dialect as follows? Receiving function not exists exception on using this function in HQL.

Postgres函数:

Postgres function:

    create or replace function ADD_DAYS(varDate timestamp without time zone, varNumber numeric) 
     returns timestamp without time zone 
     LANGUAGE sql AS    
    $$ 
     SELECT (varDate + varNumber * INTERVAL '1 day')
    $$;

Java代码:

registerFunction("add_days", new SQLFunctionTemplate(StandardBasicTypes.DATE, "add_days(?1 , ?2)"));

推荐答案

我也遇到过类似的问题.问题出在以下方面:

I have faced with the similar problem. The problem was in the following:

该函数是在特定的模式 TEST_SCHEMA 中创建的.当我使用以下配置时:

The function was created in the particular schema TEST_SCHEMA. When I used the following configuration:

<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/postgres</property>
<property name="hibernate.default_schema">TEST_SCHEMA</property>

我得到了:

org.postgresql.util.PSQLException: ERROR: function levenshtein(character varying, character varying) does not exist. No function matches the given name and argument types. You might need to add explicit type casts.

但是，当我在连接网址中明确指定默认架构时，如下所示

But, when I specified the default schema explicitly in the connection url like below

<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/postgres?currentSchema=TEST_SCHEMA</property>

我的功能可见.

这篇关于休眠方言中用户定义的PostgreSQL函数会引发异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！