Talend community forum / Question about tMap and some information associated with it

yoo9189 · 2012-07-12 03:11:34

Tags: [context, CSV file, database, java, mysql, oracle]

Hi,

I have a simple import job

so the sequence is like this

tMysqlInput -> tMap -> tOracleOutput

and what I would like to do is, I would like to some how keep track of what is the latest data (variable) is getting processed.

and I would like to access these information outside the subjob there

so what I would like to do is

tMysqlInput -> tMap -> tOracleOutput
|
| (onSubJobError)
v
tJava (maybe printout which variables the process is getting stuck on)

and exactly what I said above when there is an error in importing to Oracle, I would like to either throw an exeception or error message, with which data it failed on.

If you can help me on this issue that would be great

Thanks

pedro · 2012-07-12 04:26:56

Hi

According to your description, I think you might select "Insert or Update" action on table of tOracleOutput and then you can get both main rows, rejects rows.

Regards,
Pedro

yoo9189 · 2012-07-13 00:38:47

Hi,

Thanks for the tip, so say when you input some data into oracle and oracle returns a error

for example : ORA-01407 error where you try to set a value to null on Not-nullable column

so when we use tLogRow on reject, then it shows some information, but I would very need to customize this (perhaps show more variables associated with that rejected entry ... etc)

and from code I see where tLogRow is triggered and etc. however since we cannot customize, what can I do?

I tried tJAVA, but it is not putting the code in place where I exactly want it to be.

b/c the printing in tLogRow occurs in [tLogRow_x main] start body part where tJava writes code in [tJava begin part] of it

If there are any other references, please let me know.

Thanks

update : now I am trying like this

tMysqlInput -> tMap -> tOracleOutput ----> main -> tLogRow
|
|
---> reject -> tMap (customizing formats) -> tLogRow

is this a better idea?

Last edited by yoo9189 (2012-07-13 00:46:38)

pedro · 2012-07-13 04:00:24

Hi

According to your description, you might use tMap or tJavaRow.
They both work.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-07-12 03:11:34

Question about tMap and some information associated with it

#2 2012-07-12 04:26:56

Re: Question about tMap and some information associated with it

#3 2012-07-13 00:38:47

Re: Question about tMap and some information associated with it

#4 2012-07-13 04:00:24

Re: Question about tMap and some information associated with it

Board footer