有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

带有TableType的java JPA+Hibernate StoredProcess

我正在尝试使用hibernate/JPA调用存储过程。SP将具有参考光标输出&;名为“t_tbl_类型”的自定义表类型

  PROCEDURE get_details (po_user       OUT SYS_REFCURSOR,
    po_cd    out t_tbl_type,
    po_number   out t_tbl_type,
                               pi_userid        in     VARCHAR2,
                               pi_location   in    VARCHAR2);


        StoredProcedureQuery query = entityManager.createStoredProcedureQuery("PKG.GET_DETAILS")
                .registerStoredProcedureParameter("PI_USERID", String.class, ParameterMode.IN)
                .registerStoredProcedureParameter("PI_LOCATION", String.class, ParameterMode.IN)
                .registerStoredProcedureParameter("PO_USER", void.class, ParameterMode.REF_CURSOR)
                .registerStoredProcedureParameter("po_cd", Object.class, ParameterMode.OUT)
                .registerStoredProcedureParameter("po_number", Object.class, ParameterMode.OUT)
                .setParameter("PI_USERID", "1").setParameter("PI_LOCATION", "New");
try {
            query.execute();

// I am getting error here
            List userOutput = query.getResultList();
        } catch (Exception e) {
            e.printStackTrace();
        }

我尝试将自定义类型输出注册为“Object.class”,void。班但我还是很高兴

UnsupportedOperationException: Type [org.hibernate.type.ObjectType@35c3d6e8] does support multi-parameter value extraction

请帮助我如何获取寄存器自定义输出参数类型&;阅读它的价值


共 (0) 个答案