db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amit Handa (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-21) ResultsetMetaData.getColumnClassName() for CLOB and BLOB datatypes is incorrect.
Date Fri, 19 Nov 2004 09:45:25 GMT
     [ http://nagoya.apache.org/jira/browse/DERBY-21?page=comments#action_55668 ]
     
Amit Handa commented on DERBY-21:
---------------------------------

The EmbeddedResultSetMetaData.getColumnClassName   
calls TypeId.getResultSetMetaDataTypeName() as shown :-


Class Name :/java/engine/org/apache/derby/iapi/types/TypeId.java
Method     : getResultSetMetaDataTypeName

       public String getResultSetMetaDataTypeName()
        {
            if (BLOB_ID == this){
               return "java.sql.Blob";
            }
            if (CLOB_ID == this){
                return "java.sql.Clob";
            }
            if (NCLOB_ID == this) {
                return "java.sql.Clob";
            }
            return getCorrespondingJavaTypeName();
        }


Rather it should be 

       public String getResultSetMetaDataTypeName()
        {
              if (BLOB_ID.equals(this)){
               return "java.sql.Blob";
            }

            if (CLOB_ID.equals(this)){
                return "java.sql.Clob";
            }
            if (NCLOB_ID.equals(this)) {
                return "java.sql.Clob";
            }
        }


> ResultsetMetaData.getColumnClassName() for CLOB and BLOB datatypes is incorrect.
> --------------------------------------------------------------------------------
>
>          Key: DERBY-21
>          URL: http://nagoya.apache.org/jira/browse/DERBY-21
>      Project: Derby
>         Type: Bug
>   Components: JDBC
>     Versions: 10.0.2.0
>     Reporter: Ramandeep Kaur
>     Priority: Minor

>
> Opening this bug on behalf of Daniel Debrunner.
> -------------------------------------------------------------
> ResultsetMetaData.getColumnClassName() for CLOB and BLOB 
> datatypes is incorrect. 
>             BLOB:               CLOB:
> jcc:        java.sql.Blob       java.sql.Clob
> Derby:      byte[]              java.lang.String
> Derby's embedded JDBC driver returns the incorrect class 
> names for BLOB and CLOB columns in a ResultSet when using the 
> ResultSetMetaData.getColumnClassName() method. Note that the 
> ResultSet.getObject() method calls are not currently supported 
> for BLOB and CLOB.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message