带有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) 个答案