Copy BLOB from ODBC db type to Oracle schema

One Star

Copy BLOB from ODBC db type to Oracle schema

Hi everybody.
I have Talend Open Studio version: 3.0.4.
I have 2 tables in different schemas: ODBC and Oracle. One field in this tables has type BLOB. I need to copy data from this field.
For this I use model tDBInput -> tMap -> tOracleOutput.
For BLOB fields types in tDBInput and tOracleOutput are Object.
I had an error in gennerated code in line:
pstmtInsert_tOracleOutput_5.setBLOB(6,(oracle.sql.BLOB) oracle_doc_version.DATA);
error : The method setBLOB(int, BLOB) is undefined for the type PreparedStatement
For working it should be pstmtInsert_tOracleOutput_5.setBlob(6,(oracle.sql.BLOB) oracle_doc_version.DATA). But where I can change this type in interface?
Please, help me to resolve this problem.
One Star

Re: Copy BLOB from ODBC db type to Oracle schema

I'm having this same error. Seems like Talend is using the wrong syntax.
One Star

Re: Copy BLOB from ODBC db type to Oracle schema

I don't know if it's the good way, but facing the same problem in 3.0.2, I modified the db_output_bulk.skeleton template file located in plugins/org.talend.designer.components.localprovider_<your version>/components/templates/ by changing setBLOB to setBlob in line 688.
Regards