# Has been shut down stream

**URL:** <https://forum.cloverdx.com/t/has-been-shut-down-stream/257>\
**Category:** CloverDX Platform\
**Created:** [December 13, 2007, 12:00am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257 "2007-12-13T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [December 13, 2007, 12:00am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257/1 "2007-12-13T00:00:00Z")

</div>

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:

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [December 13, 2007, 9:23am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257/2 "2007-12-13T09:23:05Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [December 14, 2007, 4:31am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257/3 "2007-12-14T04:31:05Z")

</div>

Sorry, my database environment is ORACLE 10g

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [December 14, 2007, 9:41am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257/4 "2007-12-14T09:41:36Z")

</div>

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 (?,?)

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [December 17, 2007, 1:01am UTC](https://forum.cloverdx.com/t/has-been-shut-down-stream/257/5 "2007-12-17T01:01:14Z")

</div>

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