You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dyre Tjeldvoll (JIRA)" <de...@db.apache.org> on 2006/03/09 18:30:41 UTC
[jira] Commented: (DERBY-1094) Make
DatabaseMetaData.getProcedureColumns() JDBC4 compliant
[ http://issues.apache.org/jira/browse/DERBY-1094?page=comments#action_12369677 ]
Dyre Tjeldvoll commented on DERBY-1094:
---------------------------------------
COLUMN_DEF (String) is the default value for the column/parameter. Legal values include "NULL" if the default value is NULL, "TRUNCATE" if the specified default value cannot be specified without truncation, or NULL if a default value was not specified.
Unless someone tell me otherwise I will return NULL
SQL_DATA_TYPE (int) is reserved for future use, and will be NULL
SQL_DATETIME_SUB (int) is reserved for future use, and will be NULL
CHAR_OCTET_LENGTH (int) is the maximum length (in bytes) for character and binary types. It is NULL for all other types.
Will add a new field to GetProcedureColumns for this.
ORDINAL_POSITION (int) Ordinal position starting from 1. 0 is returned for the procedure's return value. (I didn't think procedures had return values...?)
Will add a new field to GetProcedureColumns for this.
IS_NULLABLE (String) ISO nullability for a column. Legal values include "YES" "NO" and ""(not SQL92 compliant). The Javadoc says 'YES (enclosed in quotes)'. What does that mean? "YES" "\"YES\"" "'YES'"? Presumably this should match the value of the JDBC 3.0 column NULLABLE? Currently this column is always 'procedureNullable", regardless of the column/parameter's type. But Derby's documentation states that it should be 'procedureNoNulls' for primitive types and 'procedureNullable' for object types: http://db.apache.org/derby/docs/dev/ref/rrefgpc1.html
SPECIFIC_NAME (String) Will return SYS.SYSALIASES.SPECIFICNAME
> Make DatabaseMetaData.getProcedureColumns() JDBC4 compliant
> -----------------------------------------------------------
>
> Key: DERBY-1094
> URL: http://issues.apache.org/jira/browse/DERBY-1094
> Project: Derby
> Type: Sub-task
> Components: JDBC
> Versions: 10.2.0.0
> Reporter: Dyre Tjeldvoll
> Assignee: Dyre Tjeldvoll
> Fix For: 10.2.0.0
>
> The result set returned by getProcedureColumns() must be extended with 7 additional columns in JDBC 4.0; COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB, CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE and SPECIFIC_NAME. The returned result set should be ordered by PROCEDURE_SCHEMA, PROCEDURE_NAME and SPECIFIC_NAME
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira