Skip to content

jdbc: metadata: ParameterMetaData support #173

Open

Description

@nicktorwald

The JDBC compliance requires java.sql.ParameterMetaData to be fully implemented.

This issue is about describing Inputs of a PreparedStatement Object and optionally of a CallableStatement.

The method PreparedStatement.getParameterMetaData returns a ParameterMetaData object describing the parameter markers that appear in the PreparedStatement object. Methods in the ParameterMetaData interface provide information about the number of parameters and their characteristics.

Example:

PreparedStatement pstmt = conn.prepareStatement(
    "SELECT * FROM BOOKLIST WHERE ISBN = ?"
);
ParameterMetaData pmd = pstmt.getParameterMetaData();
int colType = pmd.getParameterType(1);

See the API specification for more details.

Activity

  1. added this to the JDBC metadata milestone on May 6, 2019
  2. Totktonada commented on May 20, 2019

    @Totktonada

    AFAIK, we cannot obtain such metainformation from Tarantool right now and it seems we have no ways to emulate this feature on the driver side. I'll move this to JDBC + transactions milestone and will try to elaborate whether we'll support such kind of metainfo in the future.

    @nicktorwald Can you please investigate how this usually implemented by other vendors? Whether they allows to obtain parameters metainfo w/o actual operation performing? If no, whether the metainfo is available after an operation?

  3. Totktonada commented on May 21, 2019

    @Totktonada
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    blockedNot ready to be implementedjdbc

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions