Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <99978.1166227402342.JavaMail.jira@brutus>
Date: Fri, 15 Dec 2006 16:03:22 -0800 (PST)
From: "Daniel John Debrunner (JIRA)" <jira@apache.org>
To: derby-dev@db.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,
In-Reply-To: <2043926736.1119304397943.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ 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