java.sql.DatabaseMetaData interface
Derby Reference Manual
307
· prepareStatement( java.lang.String, int[] )
· prepareStatement( java.lang.String, java.lang.String[] )
· setTypeMap( java.util.Map )
java.sql.DatabaseMetaData interface
This section discusses
java.sql.DatabaseMetaData
functionality in Derby.
The Derby implementation of the getResultSetHoldability method returns
ResultSet.HOLD_CURSORS_OVER_COMMIT.
DatabaseMetaData result sets
DatabaseMetaData result sets do not close the result sets of other statements, even
when auto-commit is set to true.
DatabaseMetaData result sets are closed if a user performs any other action on a JDBC
object that causes an automatic commit to occur. If you need the DatabaseMetaData
result sets to be accessible while executing other actions that would cause automatic
commits, turn off auto-commit with setAutoCommit(false).
java.sql.DatabaseMetaData.getProcedureColumns method
Derby supports Java procedures. Derby allows you to call Java procedures within SQL
statements. Derby returns information about the parameters in the getProcedureColumns
call. If the corresponding Java method is overloaded, it returns information about each
signature separately. Derby returns information for all Java procedures defined by
CREATE PROCEDURE.
getProcedureColumns returns a ResultSet. Each row describes a single parameter or
return value.
Parameters to getProcedureColumns
The JDBC API defines the following parameters for this method call:
· catalog
always use null for this parameter in Derby.
· schemaPattern
Java procedures have a schema.
· procedureNamePattern
a String object representing a procedure name pattern.
· column-Name-Pattern
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.
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
