I'm trying to load a table through the tOracleOutput component. I have a table which has a column defined as:
CREATE TABLE TEST_NULL ( COLUMN1 varchar2(200) , DEFAULT_VALUE NUMBER DEFAULT '-1' NOT NULL )
now I can't seem to be able to find a working combination, together with the tOracleOutput component, which is able to use this table definition.
I either get nullpointer exceptions in my job, or "cannot insert null value" oracle errors.
Alternatively I see that the tOracleOutput component has got a "default" column, but also from that option I can't seem to find any documentation, or get it to work.
If DEFAULT_VALUE column is in your tOracleOutput schema, you MUST have a value for it to avoid oracle error. The null pointer exception comes from elsewhere. I think so.
well, the weird thing is, if I define my column as "MY_COLUMN NUMBER DEFAULT '-1' " (without the "NOT NULL") then the job works fine, but it actually inserts a NULL, instead of using the default value which I specify in my Oracle DDL (or in the "Default" field of the tOracleOutput component). Is there any way to have null's not explicity written?
With oracle, default value is set to the associated column only if this column doesn't participate to the insert operation. As soon as the field is in Talend schema, the column participate to the insert and the default doesn't apply.
OK, in that case what would be the cleanest solution to make sure that my null values get replaced by another value (-1 in this case) I would presume that the "Default" option in the tOracleOutput component is used for that, right? Or is that for something completely different? in which case is this "default" value used, because I can't get it working neither.
Not sure it works with tOracleOutput. Some topic about that in the ancient forum. Maybe the default defined in the schema can be accessed in Java, but looks a little complicated.
The database output components won't add a default value for you when you write data to Oracle. You'll either need to handle missing values in a tMap or you can potentially handle them on input, depending on what your input source is.
