java - jpa中如何调用表函数

Question

我一直在尝试调用我使用 jpa 创建的函数，但我不断收到此错误

(org.eclipse.persistence.exceptions.DatabaseException内部异常:com.microsoft.sqlserver.jdbc.SQLServerException:“udf_searchEmployeeLeaves”不是可识别的内置函数名称。错误代码:195)

public List<EmployeeLeaves> searchEmployeeLeaves(String str) throws EmployeeLeavesException {

    try {
        Query query = em.createNativeQuery("SELECT udf_searchEmployeeLeaves(?1) FROM LAB ");

        query.setParameter(1, str);

        return query.getResultList();

    } catch (Exception e) {

        throw new EmployeeLeavesException("[searchEmployeeLeaves-ERROR]: " + e.getMessage());

    }

}

Answer 1

我认为该调用不正确。

您必须像这样调用表函数:

Query query = em.createNativeQuery("SELECT * FROM udf_searchEmployeeLeaves(?1)");