java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect 不支持通过存储过程的结果集 [英] java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support resultsets via stored procedures

问题描述

如何解决以下错误我使用的是 JPA 2.1 widfly Application Server 8.0 和 Oracle 11g bd

how to solve the following error I am using JPA 2.1 widfly Application Server 8.0 and Oracle 11g bd

java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect 不支持通过存储过程的结果集

java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support resultsets via stored procedures

副码:

        StoredProcedureQuery storedProcedureQuery=em.createStoredProcedureQuery("SIB_PQ_SENA.CREAR_VENTAS",Venta.class);
    storedProcedureQuery.registerStoredProcedureParameter("P_ID_EMPLEADO", Integer.class , ParameterMode.IN);
    storedProcedureQuery.registerStoredProcedureParameter("P_ID_CLIENTE", Integer.class, ParameterMode.IN);
    storedProcedureQuery.registerStoredProcedureParameter("P_ID_SUCURSAL", Integer.class, ParameterMode.IN);
    storedProcedureQuery.registerStoredProcedureParameter("CURSORRETURN", void.class, ParameterMode.REF_CURSOR);
    storedProcedureQuery.setParameter("P_ID_EMPLEADO", idEmpleado);
    storedProcedureQuery.setParameter("P_ID_CLIENTE", idCliente);
    storedProcedureQuery.setParameter("P_ID_SUCURSAL", idSucursal);
    storedProcedureQuery.execute();

推荐答案

Wildfly 8 使用 Hibernate 4.3.

Wildfly 8 uses Hibernate 4.3.

此问题是由 HHH-9286 引起的，该问题已在 Hibernate 5.1 中得到修复.0 和 5.0.8.

This issue was caused by HHH-9286 which got fixed in Hibernate 5.1.0 and 5.0.8.

您需要升级 Hibernate 才能修复它.为了证明这一点，您可以运行以下示例 博文.所有的例子都在 GitHub，因此您可以针对您使用的任何 Hibernate 版本进行测试.

You need to upgrade Hibernate to get it fixed. To prove it, you can run the examples from this blog post. All the examples are on GitHub, so you can test against any Hibernate version you use.

这篇关于java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect 不支持通过存储过程的结果集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！