Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <11927486.1174325852209.JavaMail.jira@brutus>
Date: Mon, 19 Mar 2007 10:37:32 -0700 (PDT)
From: "Suresh Thalamati (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (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


     [ https://issues.apache.org/jira/browse/DERBY-378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Thalamati updated DERBY-378:
-----------------------------------

    Attachment: derby378_5.diff

DERBY-378 (partial)
This patch adds some code required to support import/exoprt of lob data.
1) Addded  code to read clob data using getCharacterStream()
instead of getString() while importing clob data from an extern file. 
(Note: Clobs are read using getString() until DERBY-2465 is fixed).
2) Made some code changes to make each lob column has it it's own file handle to
   the lob file to read the data, otherwise streams can get corrupted when 
   there are more than one clob/blob type column in the table.

> 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: https://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: derby378_1.diff, derby378_1.stat, derby378_2.diff, derby378_2.stat, derby378_3.diff, derby378_3.stat, derby378_4.diff, derby378_4.stat, derby378_5.diff, 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.
-
You can reply to this email to add a comment to the issue online.