delimiter //

create or replace procedure test(p1 int, p2 int)

BEGIN

select p1 as 'p1';

END

//

delimiter //

create or replace procedure test(p1 int)

BEGIN

select p1 as 'p1';

END

//

import java.sql.*;

public class GetProcedureColumnsRepro {

  public static void execute() throws SQLException {

    String jdbcUrl = "jdbc:mariadb://localhost:3306/YOURDB";

//    String jdbcUrl = "jdbc:mysql://localhost:3306/YOURDB";

    String userName = "yourusername";

    String password = "yourpassword";

    String spName = "yourstoredprocedurename";

    try (Connection conn = DriverManager.getConnection(jdbcUrl, userName, password)) {

      System.out.println("---");

      DatabaseMetaData databaseMetaData = conn.getMetaData();

      // EXECUTE A STORED PROCEDURE

      try (CallableStatement call = conn.prepareCall("{call " + spName + "(?, ?)}")) {

        call.setQueryTimeout(0);

        call.setObject(1, 1);

        call.setObject(2, 2);

        call.execute();

      } catch (Exception e) {

        System.out.println("Should not have encountered error here. Make sure the procedure was created before starting the repro: " + e.getMessage());

        throw e;

      }

      // LOOP FOREVER, REPORTING THE PROCEDURE'S PARAMETERS

      while (true) {

        try (ResultSet rs = databaseMetaData.getProcedureColumns(null, null, spName, null)) {

          String columns = "";

          while (rs.next()) {

            columns += rs.getString("COLUMN_NAME") + ",";

          }

          System.out.println("GetProcedureColumns found: " + columns);

        }

      }

    } catch (Exception e) {

      System.out.println("e: " + e.getMessage());

    }

  }

}