Message-ID: <gh-pgjdbc-pgjdbc-3564-c3018326496@github.com>
From: "raminorujov (@raminorujov)" <noreply+raminorujov@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 30 Jun 2025 08:51:14 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3564: CallableStatement.getParameterMetadata returns wrong parameter mode
In-Reply-To: <gh-pgjdbc-pgjdbc-3564@github.com>
References: <gh-pgjdbc-pgjdbc-3564@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: raminorujov
X-GitHub-Comment-Id: 3018326496
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-06-30T08:53:24Z
X-GitHub-Issue: 3564
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3564#issuecomment-3018326496
Content-Type: text/plain; charset=utf-8

@DmitriyGod it's hardcoded to always return mode IN and ignores output parameters :)
See doc https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/jdbc/PgParameterMetaData.html#getParameterMode-int-

```
 /**
   * {@inheritDoc} For now report all parameters as inputs. CallableStatements may have one output,
   * but ignore that for now.
   */
  @Override
  public int getParameterMode(int param) throws SQLException {
    checkParamIndex(param);
    return ParameterMetaData.parameterModeIn;
  }
```