Cannot receive multiple output parameters from stored procedure with @NamedStoredProcedureQuery [DATAJPA-1722]

[spring-projects-issues]

AlexanderStepchkov opened DATAJPA-1722 and commented

I'm trying to receive out parameters from simple stored procedure (using Oracle 11g and/or MSSQL 2012).

CREATE OR REPLACE PROCEDURE test_sp(x OUT INTEGER, y OUT INTEGER) AS
BEGIN
 x := 17; y := 93;
END;

 

@Data
@Entity
@NamedStoredProcedureQueries({
        @NamedStoredProcedureQuery(name = "testSp", procedureName = "test_sp", parameters = {
                @StoredProcedureParameter(mode = ParameterMode.OUT, name = "x", type = Integer.class),
                @StoredProcedureParameter(mode = ParameterMode.OUT, name = "y", type = Integer.class)
        })
})
public class SomeEntity {
    @Id
    private Long id;
}

Please check attached demo project for details.

Using annotations I always receive errors: 

java.lang.IllegalArgumentException: OUT/INOUT parameter not available: x

java.lang.IllegalArgumentException: OUT/INOUT parameter not available: 1

However if I use entityManager's createStoredProcedureQuery method it works fine.

 

Link to SO https://stackoverflow.com/questions/61655464/spring-boot-data-jpa-receive-multiple-out-parameters-from-sql-servers-stored-pr

---

Affects: 2.2.7 (Moore SR7)

Attachments:

• demo.zip (5.83 kB)

1 votes, 2 watchers

[satscreate]

Any update on this issue using @procedure annotation?

[schauder]

The example relies on downloading oracles jdbc driver which resolves as forbidden, it also doesn't come with a database.

Please provide a reproducer that uses an in memory database or brings everything it needs with it, using for example Testcontainers.

If the reproducer is highly database dependent it's likely that the issue is really one of the JPA implementation, i.e. Hibernate in this case. After all Spring Data JPA is based on JPA which is supposed to provide an abstraction over the different databases.

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[satscreate]

Am on it...will create a quick in memory db setup and attach shortly.

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[spring-projects-issues]

Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue.