Error copy Data base With Dynamic Schema

Anonymous — Thu, 26 Nov 2015 09:52:52 GMT

Hello,

I transfer my data base which come from MSQL Server for going Oracle. I use job with a iteration on all tables and the all tables are transfered one per one with two components tmssqlinput and toracleoutput with dynamic schema.
So i have two problems and i don't find a solution :

- On MSSQL Server i have fields which returns values "null" but in Oracle DB my fields can't accept values "NULL". My field in Oracle have a default value. How to do for replace value NULL per "" or 0

- Second problem is.. On MSSQL i have an Image in MSQL DB..... :-/And on oracle the field is BLOB, i have error : "java.sql.SQLException:Invalid column type". I have tchek the mapping talend (on windows->preference->specific setting->Metada of Talend) and they are same for the two DB.

My version talend is 6.0.1.20150908_1633

Thank for your help,

Re: Error copy Data base With Dynamic Schema

Anonymous — Thu, 26 Nov 2015 15:45:36 GMT

Both problems are hard to solve. You have to think about the dynamic schema as a Map with the column names as keys and the column values as values in the map.
The problem with null values can only be solved with coalesce in the query. The default values in the target table definition only applies if you do not set any value (also null) in the insert/update statement. This is a common misconception about the default values in a table.

BLOBs are often different stored inside the databases and Talend has actually no dedicated type for this.
Take care you set for the BLOB columns as type Object instead of byte[]. This should work.

topic Error copy Data base With Dynamic Schema in Talend Studio

Error copy Data base With Dynamic Schema

Re: Error copy Data base With Dynamic Schema