Has been shut down stream

CloverDX Platform
1

Long type and blob types at the same time, the court into a problem is derived. Output “has been shut down stream”

source table structure:
create table t1 (c1 blob ,c2 long);

target table structure:
create table t2 (c1 blob ,c2 long);

DB_INPUT_TABLE → DB_OUTPUT_TABLE

fmt file:



2

Hello,
I haven’t found any problem on MySql database. Isn’t the problem in the metadata? Length and scale can be specified for decimal field only and size shouldn’t be specified fro delimited metadata.

3

Sorry, my database environment is ORACLE 10g

4

Hi,
I thing that problem is in jdbc oracle driver: after calling method getBytes or getBlob can’t be called other type call method. I’ve found workaround to solve your problem: change field’s order in metadata and in sql queries - that means:

- long type in Oracle: Character data of variable length (A bigger version the VARCHAR2 datatype)


and sqlQuery in input table:
select c2, c1 from t1
sqlQuery in output table
insert into (c2, c1) values (?,?)

5

Thank you very much for the patience to answer, was touched by your professionalism(open sources), this should be oracle jdbc driven bug.