db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-378) support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,
Date Sat, 16 Dec 2006 00:03:22 GMT
    [ http://issues.apache.org/jira/browse/DERBY-378?page=comments#action_12458976 ] 
            
Daniel John Debrunner commented on DERBY-378:
---------------------------------------------

For reading from a VTI I'm not sure why CLOB and BLOB are not supported. SQLBlob seems to
contain the correct code in its setValueFromResultSet(). It might be a hangover from the time
the codebase supported JDK 1.1 and java.sql.Blobs were not available. It might be simply the
work was never done. What error do you get?

For setting BLOB/CLOB into a VTI it might be tricker, since it requires the SQL layer to be
able to manufacture a java.sql.Blob object, and since they are JDBC objects the language doesn't
handle them. Though it's a simiar problem to BLOBs in triggers/functions and I think at least
for triggers it works, so I think there is a mechanism for creating a java.sql.Blob from a
BLOB column.

and having written that, I thought BLOBs were used in triggers and triggers used VTIs ...

> support for  import/export  of  tables with clob/blob and the other binary data types
  will be good addition to derby,
> -----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-378
>                 URL: http://issues.apache.org/jira/browse/DERBY-378
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects Versions: 10.1.1.0
>            Reporter: Suresh Thalamati
>         Assigned To: Suresh Thalamati
>         Attachments: iexlobs.txt
>
>
> Currently if  I have  a table that contains clob/blob column,  import/export operations
on that table
> throghs  unsupported feature exception. 
> set schema iep;
> set schema iep;
> create table ntype(a int , ct CLOB(1024));
> create table ntype1(bt BLOB(1024) , a int);
> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
>                                  null, null, null) ;
> ERROR XIE0B: Column 'CT' in the table is of type CLOB, it is not supported by th
> e import/export feature.

-- 
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