"Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: Dialect [org.hibernate.dialect.SQLServer2008Dialect] not known to support REF_CURSOR parameters" in EAP.

Issue

• Using the Hibernate dialect org.hibernate.dialect.SQLServer2008Dialect

• Exception occurred while executing the stored procedure with an OUT parameter of type REF_CURSOR

  ... org.hibernate.QueryException: Dialect [org.hibernate.dialect.OracleDialect] not known to support REF_CURSOR parameters
      at org.hibernate.procedure.internal.StandardCallableStatementSupport.verifyRefCursorSupport(StandardCallableStatementSupport.java:76)
      at org.hibernate.procedure.internal.StandardCallableStatementSupport.renderCallableStatement(StandardCallableStatementSupport.java:59)
      at org.hibernate.procedure.internal.ProcedureCallImpl.buildOutputs(ProcedureCallImpl.java:384)
      at org.hibernate.procedure.internal.ProcedureCallImpl.getOutputs(ProcedureCallImpl.java:363)
      at org.hibernate.jpa.internal.StoredProcedureQueryImpl.outputs(StoredProcedureQueryImpl.java:234)
      at org.hibernate.jpa.internal.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:217)
      ...