Columns in the ResultSet returned by getProcedureColumns

Columns in the ResultSet returned by getProcedureColumns are as described by the API. Further details for some specific columns:
  • PROCEDURE_CAT

    always "null" in Derby

  • PROCEDURE_SCHEM

    schema for a Java procedure

  • PROCEDURE_NAME

    the name of the procedure

  • COLUMN_NAME

    the name of the parameter (see column-Name-Pattern)

  • COLUMN_TYPE

    short indicating what the row describes. Always is DatabaseMetaData.procedureColumnIn for method parameters, unless the parameter is an array. If so, it is DatabaseMetaData.procedureColumnInOut. It always returns DatabaseMetaData.procedureColumnReturn for return values.

  • TYPE_NAME

    Derby-specific name for the type.

  • NULLABLE

    always returns DatabaseMetaData.procedureNoNulls for primitive parameters and DatabaseMetaData.procedureNullable for object parameters

  • REMARKS

    a String describing the java type of the method parameter

  • COLUMN_DEF

    a String describing the default value for the column (may be null)

  • SQL_DATA_TYPE

    reserved by JDBC spec for future use

  • SQL_DATETIME_SUB

    reserved by JDBC spec for future use

  • CHAR_OCTET_LENGTH

    the maximum length of binary and character based columns (or any other datatype the returned value is a NULL)

  • ORDINAL_POSITION

    the ordinal position, starting from 1, for the input and output parameters for a procedure.

  • IS_NULLABLE

    a String describing the parameter's nullability (YES means parameter can include NULLs, NO means it can't)

  • SPECIFIC_NAME

    the name which uniquely identifies this procedure within its schema

  • METHOD_ID

    a Derby-specific column.

  • PARAMETER_ID

    a Derby-specific column.

Related reference
DatabaseMetaData result sets
java.sql.DatabaseMetaData.getProcedureColumns method
Parameters to getProcedureColumns
java.sql.DatabaseMetaData.getBestRowIdentifier method