[ 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
