Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Wrong sequence of named parameters for stored procedure call

Description

I am using Hibernate 4.3 final as JPA vendor,
When I call store procedure using StoredProcedureQuery in named parameter way, sequence of result is wrong. Then I check source and found that hibernate call procedure in position parameter way even I want named parameter way.
Another problem is also cause by same reason, if I register OUT parameter first, there is no result return.
Why call procedure using named parameter is I want it not so tight between program and procedure, but hibernate seems can not achieve this aim now.

Attachments

3
  • 08 Oct 2021, 02:50 PM
  • 07 Jan 2014, 10:05 AM
  • 07 Jan 2014, 10:05 AM

Activity

Show:

Christian Beikov January 20, 2025 at 3:34 PM

Sergio Kosik October 8, 2021 at 2:35 PM
Edited

Hello. I face the issue. My environment is following:

hibernate-core, hibernate-entitymanager - 5.5.7.Final

java version 11.0.12

hibernate-core, hibernate-entitymanager, hibernate-c3p0 - 5.5.7.Final
hibernate-jpa-2.1-api 1.0.2.Final

spring-boot-starter-web, spring-orm, spring-tx spring-data-jpa - 5.1.3.RELEASE
spring-data-jdbc - 2.2.5

javaee-api 7.0
javax.enterprise, cdi-api - 2.0.SP1

<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.6.0.0</version>
</dependency>

 

See attached report-output.txt log file.

Former user May 25, 2016 at 11:22 PM

Mitchell Herrijgers November 19, 2015 at 8:27 AM

I can confirm this is still the case in Hibernate 5.0.0.Final.

See stackoverflow post here: http://stackoverflow.com/questions/33776378/hibernate-mixes-stored-procedure-output-parameters/33781121#33781121

Steve Ebersole October 28, 2015 at 3:24 AM

As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.

Duplicate

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Created January 7, 2014 at 10:05 AM
Updated January 20, 2025 at 3:34 PM
Resolved January 20, 2025 at 3:34 PM
Configure