I also added the fix for removing metadata lookup for named parameters. This will break the existing applications that use a mix of named and index parameters.
For example for a proc like:

CREATE PROCEDURE proc (
    @par1 INT = NULL
) AS
BEGIN
	insert into tempTable values (@par1)
END

If we need to use named parameters to get the output parameters, we need to register the parameter with name values:

callableStatement.registerOutParameter("@par1", java.sql.Types.INTEGER);
callableStatement.execute();

and then call:
callableStatement.getObject("@par1");

Registering output parameter with name and using indexes to retrieve them, however, still works.

Hello mssql-jdbc team, can you please let me know when this will be merged and released?

Hi @praskutti ,
The PR is incomplete and requires quite some changes to merge it. It is in our backlog to address them, but there is no timeline currently.

Hi @praskutti ,
The PR is incomplete and requires quite some changes to merge it. It is in our backlog to address them, but there is no timeline currently.

Thanks @ulvii . I coded a usable workaround for our requirement (to create a generic method for SQL Server proc calls that would avoid extra metadata lookups). I thought this PR would solve it, but because it will take time to release, we will roll with our method. I will post the code-sample soon.

This is still being worked on #2154.