[ https://issues.apache.org/jira/browse/DERBY-378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Thalamati updated DERBY-378:
-----------------------------------
Attachment: derby378_1.stat
derby378_1.diff
DERBY -378 (partial)
This patch adds some code required to support import/export of table with
clob, blob(large objects) data types. Clob/Blobs data can be exported to
an external file that different from the main export file. Location of the
lob data in the external file will be written to the main export file.
When writing the lob data to an external file, no conversion is done for the
binary data , clob data will be written using the user specified code set.
1)This patch implements following two new procedure to support
exporting LOBS to an external file name:
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_IN_EXTFILE(..)
SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_IN_EXTFILE(..)
2)This patch implements following two new procedure that allow
import of large object data stored in a external file.
(for example exported previously using the above export procedures).
SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_IN_EXTFILE(...)
SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_IN_EXTFILE(..)
3) import/export of table with clob,blob types will also work
with single input/output file, using the exiting import/export
procedures. In this can binary data is converted into hex format before
exporting and the data hex is converted to binary on import.
Clob data is exported similar to other char types.
Tests: derbyall/junitall test suites passed on Windows XP/JDK142, except
for the known failures.
> 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, 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.
|