StoredProcedureQuery with Multiple out parameter not working after hibernate(6) and java (17) upgrade

Question

Earlier StoredProcedureQuery with two out parameter is working. I successfully called a stored procedure with two out and multiple IN parameters. But after java and hibernate upgrade it is not working as expected. (in stored procedure char, String, Integer IN and OUT parameter)

I want to called stored procedure with two OUT and multiple IN parameters in hibernate 6 and java 17.

Answer 1

After upgrading to Java 17 and hibernate 6, the sequence of IN parameter was changed. I was able to fix this by changing the sequence while sending the IN parameter to the procedure.