db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dyre Tjeldvoll (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1094) Make DatabaseMetaData.getProcedureColumns() JDBC4 compliant
Date Thu, 09 Mar 2006 17:30:41 GMT
    [ 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


Mime
View raw message