[
http://issues.apache.org/jira/browse/DERBY-378?page=comments#action_12458978 ]
Suresh Thalamati commented on DERBY-378:
----------------------------------------
Thanks for the input Dan. When I specify the column type for import VTI as
Types.BLOB , I got the following error :
"The external virtual table interface does not support BLOB or CLOB columns.
''{0}'' column ''{1}''. "
This error is coming from impl/sql/compile/FromVti.java
if( columnType == Types.BLOB || columnType == Types.CLOB)
throw
StandardException.newException(SQLState.LANG_VTI_BLOB_CLOB_UNSUPPORTED,
getVTIName(), rsmd.getColumnName( i));
I will check out triggers with BLOBS.
> 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
