NamedStoredProcedureQuery not supporting IN parameters with DB2

[javatype]

Hi,

My Procedure call was working fine before spring upgrade.

I am using below dependencies -
org.springframework.boot:spring-boot-starter-data-jpa🫙3.1.3, with which getting
jakarta.persistence:jakarta.persistence-api:jar:3.1.0

@Entity
@NamedStoredProcedureQuery(name = "myProcc",
        procedureName = "MYPROC",
        parameters = {
                @StoredProcedureParameter(mode = ParameterMode.IN, name = "KEYTYPE", type = String.class),
                @StoredProcedureParameter(mode = ParameterMode.OUT, name = "SOME_ID", type = Long.class)
        })
public class MyGenerationEntity {
  @Id
  @Column(name = "SOME_ID")
  Long keyType;
}

@Repository
public interface MyRepository extends JpaRepository<MyGenerationEntity, Long>{
  @Procedure(name = "myProcc", outputParameterName = "SOME_ID")
  @Transactional
  Long getKey(@Param("KEYTYPE") String keyType);
}

Now, when I call this in code, I am getting below exception.
Db is DB2.

 Error Detail:Unexpected character ':' found in FLOAT literal.  Full SQL statement text
= call MYPROC(:KEYTYPE,:SOME_ID)  ERRORCODE=-4463, SQLSTATE=42601] [{call MYPROC(:KEYTYPE,:SOME_ID)}];

[gregturn]

Related to #3085.

Have you picked up our latest Spring Data release (either https://spring.io/blog/2023/09/15/spring-data-2023-1-0-m3-released or https://spring.io/blog/2023/09/15/spring-data-2023-0-4-2022-0-10-and-2021-2-16-released), because we have a patch that stops mangling named queries, which looks like what may have happened to you.

Or...it may have nothing to do with you given you are using a stored procedure.

[javatype]

could not find latest dependency out there on maven. any temporary fix?

[mp911de]

If you would like us to spend some time helping you to diagnose the problem, please spend some time describing it and, ideally, providing a minimal yet complete sample that reproduces the problem.
You can share it with us by pushing it to a separate repository on GitHub or by zipping it up and attaching it to this issue.

[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.