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 are shown -in the following table.

Columns in the ResultSets returned by +getFunctionColumns and getProcedureColumns are +as described by the API.

The following table shows +-specific details for +some specific columns returned by getFunctionColumns.

Columns in the ResultSet returned by -getProcedureColumns -This table lists and describes the columns in the ResultSet returned by the getProcedureColumns method. +getFunctionColumns +This table lists and describes -specific details for some columns in the ResultSet returned by the getFunctionColumns method. @@ -37,24 +40,64 @@ in the following table.

-PROCEDURE_CAT -Always "null" in -. +COLUMN_TYPE +short indicating what the row describes. Is always +DatabaseMetaData.functionColumnIn for method parameters, unless the +parameter is an array. If so, it is DatabaseMetaData.functionColumnInOut. +It always returns DatabaseMetaData.functionColumnReturn for return +values. -PROCEDURE_SCHEM -Schema for a Java procedure. +TYPE_NAME +-specific +name for the type. -PROCEDURE_NAME -The name of the procedure. +NULLABLE +Always returns DatabaseMetaData.functionNoNulls for +primitive parameters and DatabaseMetaData.functionNullable for object +parameters. -COLUMN_NAME -The name of the parameter (see columnNamePattern in -). +REMARKS +A String which describes the Java type of the method +parameter. +ORDINAL_POSITION +The ordinal position, starting from 1, for the input +and output parameters for the function. + + +METHOD_ID +A -specific +column. + + +PARAMETER_ID +A -specific +column. + + + +

The following table shows +-specific details for +some specific columns returned by getProcedureColumns.

+Columns in the ResultSet returned by +getProcedureColumns +This table lists and describes -specific details for some columns in the ResultSet returned by the getProcedureColumns methods. + + + + + +Column +Description + + + + COLUMN_TYPE short indicating what the row describes. Is always DatabaseMetaData.procedureColumnIn for method parameters, unless the @@ -79,37 +122,9 @@ parameters. parameter. -COLUMN_DEF -A String which describes the default value for the -column (may be null). - - -SQL_DATA_TYPE -Reserved by the JDBC specification for future use. - - -SQL_DATETIME_SUB -Reserved by the JDBC specification for future use. - - -CHAR_OCTET_LENGTH -The maximum length of binary and character based columns (for -any other data type, 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 the parameter can include NULLs, NO means it cannot). - - -SPECIFIC_NAME -The name which uniquely identifies this procedure within -its schema. +and output parameters for the procedure. METHOD_ID Modified: db/derby/docs/branches/10.10/src/ref/rrefdmdfns1.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefdmdfns1.dita?rev=1531356&r1=1531355&r2=1531356&view=diff ============================================================================== --- db/derby/docs/branches/10.10/src/ref/rrefdmdfns1.dita (original) +++ db/derby/docs/branches/10.10/src/ref/rrefdmdfns1.dita Fri Oct 11 17:04:16 2013 @@ -20,21 +20,22 @@ limitations under the License. --> java.sql.DatabaseMetaData.getBestRowIdentifier method -The java.sql.DatabaseMetaData.getBestRowIdentifier method -looks for identifiers in a specific order. This order might not return a unique -row. java.sql.DatabaseMetaData.getBestRowIdentifier method methodsjava.sql.DatabaseMetaData.getBestRowIdentifier -

The java.sql.DatabaseMetaData.getBestRowIdentifier method +

The java.sql.DatabaseMetaData.getBestRowIdentifier method +looks for identifiers in a specific order. This order might not return a unique +row.

The java.sql.DatabaseMetaData.getBestRowIdentifier method looks for identifiers in the following order:

A primary key on the table
A unique constraint or unique index on the table
All of the columns in the table

If the java.sql.DatabaseMetaData.getBestRowIdentifier method +

If the java.sql.DatabaseMetaData.getBestRowIdentifier method does not find a primary key, unique constraint, or unique index, the method must look for identifiers in all of the columns in the table. When the method looks for identifiers this way, the method will always find a set of columns Modified: db/derby/docs/branches/10.10/src/ref/rrefgpc1.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefgpc1.dita?rev=1531356&r1=1531355&r2=1531356&view=diff ============================================================================== --- db/derby/docs/branches/10.10/src/ref/rrefgpc1.dita (original) +++ db/derby/docs/branches/10.10/src/ref/rrefgpc1.dita Fri Oct 11 17:04:16 2013 @@ -1,38 +0,0 @@ - - - - - -java.sql.DatabaseMetaData.getProcedureColumns method - -java.sql.DatabaseMetaData.getProcedureColumns method - - -

supports -Java procedures. allows -you to call Java procedures within SQL statements. returns -information about the parameters in the getProcedureColumns call. If -the corresponding Java method is overloaded, it returns information about -each signature separately. returns -information for all Java procedures defined by CREATE PROCEDURE.

getProcedureColumns returns a ResultSet. Each row -describes a single parameter or return value.

- - - Modified: db/derby/docs/branches/10.10/src/ref/rrefjdbc15905.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefjdbc15905.dita?rev=1531356&r1=1531355&r2=1531356&view=diff ============================================================================== --- db/derby/docs/branches/10.10/src/ref/rrefjdbc15905.dita (original) +++ db/derby/docs/branches/10.10/src/ref/rrefjdbc15905.dita Fri Oct 11 17:04:16 2013 @@ -24,8 +24,13 @@ limitations under the License. java.sql.DatabaseMetaData interface -

This section discusses java.sql.DatabaseMetaData functionality in . +

This section discusses java.sql.DatabaseMetaData +functionality in .

For methods that take a catalog parameter, always specify null for +this parameter, since +does not support catalogs. Similarly, methods that return a catalog in the +ResultSet will always return null in that column.

The implementation of the getResultSetHoldability method returns ResultSet.HOLD_CURSORS_OVER_COMMIT. Modified: db/derby/docs/branches/10.10/src/ref/rrefpgc1.dita URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/ref/rrefpgc1.dita?rev=1531356&r1=1531355&r2=1531356&view=diff ============================================================================== --- db/derby/docs/branches/10.10/src/ref/rrefpgc1.dita (original) +++ db/derby/docs/branches/10.10/src/ref/rrefpgc1.dita Fri Oct 11 17:04:16 2013 @@ -1,67 +0,0 @@ - - - - - -Parameters to getProcedureColumns - -

For the getProcedureColumns method, the JDBC API defines the -parameters shown in the following table.

getProcedureColumns method parameters -This table lists and describes the parameters of the getProcedureColumns method. - - - - - -Parameter -Description - - - - -catalog -Always use null for this parameter in -. - - -schemaPattern -A String object representing the name pattern of the -procedure's schema. Java procedures have a schema. - - -procedureNamePattern -A String object representing the name pattern of the -procedure. - - -columnNamePattern -A String object representing the name pattern of the -parameter names or return value names. Java procedures have parameter names -matching those defined in the CREATE PROCEDURE statement. Use "%" to find all -parameter names. - - - -

- - -