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.
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