topic Re: Unable to transfer blob from Oracle to Mysql using tDBoutputBulk in Talend Studio

Unable to transfer blob from Oracle to Mysql using tDBoutputBulk

Anonymous — Thu, 20 Dec 2018 14:00:07 GMT

I'm trying as an exercise to understand the behaviour of components to transfer blob from Oracle to Mysql using tDBoutputBulk.

     ┌──────┐          ┌─────────────┐
     │Oracle│          │tDbOutputBulk│
     └──┬───┘          └──────┬──────┘
        │  dump Oracle Table  │       
        │ ───────────────────>│       
     ┌──┴───┐          ┌──────┴──────┐
     │Oracle│          │tDbOutputBulk│
     └──────┘          └─────────────┘

When it saves the row to the file , the blob is transferred as a string like this:

<startlob>oracle.sql.BLOB@20a25f66<endlob>

And not like a Base64 cell block.

I tried to use either the oracle or mysql format but the result is similar.

When I try to import directly to a mysql DB it runs fine and it transfer the blob correctly in the other DB

Where is the blob ?

Thank you

Paolo

Re: Unable to transfer blob from Oracle to Mysql using tDBoutputBulk

Anonymous — Thu, 20 Dec 2018 17:13:12 GMT

Hi,

Could you please go through the below community posts and let us know whether they have helped you?

https://community.talend.com/t5/Design-and-Development/resolved-insert-blob-in-Oracle-component/td-p/90757

https://community.talend.com/t5/Design-and-Development/resolved-Create-file-from-a-blob-input-oracle-db/td-p/92265

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Unable to transfer blob from Oracle to Mysql using tDBoutputBulk

Anonymous — Fri, 21 Dec 2018 09:32:40 GMT

thank you very much for the reply.

The first solution does not solve the problem, the second use another component that save only the blob, but i'm unable to make it work.

However the output bulk is needed to reload the table into another DB.

I think the error come from an incorrect cast in generated java:

if (row1.T_LOGS_BIN != null) {

row_tDBOutputBulk_1[10] = String
.valueOf(row1.T_LOGS_BIN);

}

it emit something like this:

oracle.sql.BLOB@351f2244

that seems the pointer representation to the object and not the object content.

I use the latest TOS_DI

Thank you

Paolo