topic Copy BLOB from ODBC db type to Oracle schema in Talend Studio

Copy BLOB from ODBC db type to Oracle schema

_AnonymousUser — Sat, 16 Nov 2024 13:58:42 GMT

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.

Re: Copy BLOB from ODBC db type to Oracle schema

Anonymous — Tue, 28 Apr 2009 20:25:12 GMT

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

Re: Copy BLOB from ODBC db type to Oracle schema

Anonymous — Thu, 04 Jun 2009 10:43:08 GMT

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