You are not logged in.
Hi, I don't know if it's the right forum because it does not display TIS in the title (the old Talend Enterprise i guess).
I have a Job that do :
tmysqlInput => "SHOW TABLE"
tMysqlInput => "SELECT * FROM "+row1.table+"" (i tried to put it in a tSetGlobalVar too. Same problem)
tmysqlOutput => with ""+row1.table+"" in the table input text.
All the Schema are with ONE column set to DYNAMIC (mysqlinput AND output)
And i got
[statistics] connected Exception in component tMysqlOutput_1 java.lang.NullPointerException at informix_exapaq.stress_test_nas_0_1.stress_test_NAS.tMysqlInput_1Process(stress_test_NAS.java:1022) at informix_exapaq.stress_test_nas_0_1.stress_test_NAS.runJobInTOS(stress_test_NAS.java:1295) at informix_exapaq.stress_test_nas_0_1.stress_test_NAS.main(stress_test_NAS.java:1169) [statistics] disconnected
What am i doing wrong ?
- I tried puttin a table name in the tMysqlOutput. Same error
- I tried putting a table name in the "SELECT *" tMysqlinput and keep the dynamic table name in the tMysqlOutput. It works.
- I tried putting the dynamic table name in the "SELECT *" tmysqlinput and put a tlog row at the place of the tmysqloutput. It works
Last edited by ffwrude (2012-05-31 15:23:09)
You said TOS so that's why i clarified.
" SHOW TABLES (Schema is set String named "table") "
Key "globaltable" => row1.table
SELECT * FROM "+((String)globalMap.get("globaltable"))+"
Table is set to ""+((String)globalMap.get("globaltable"))+""
Did you put DYNAMIC schema and have like 3tables with different structures ?
Table2 var(varchar-255), tatayoyo(id 25),trululu(int 20)
I can't reproduce this issue, either.
The dynamic feature is dynamic feature. There isn't any workaround. Sorry.
Could you show us the screenshot of your job, the settings of component?
Ok, before doing that i just tried something and it's odd.
When i put a tJava after the tMysqlInput3 and ask him to "system.print" row1.table and then tMysqlInput3.QUERY
SELECT * FROM table2
And i just found that table1 is empty. Could it come from there ?
COuld it be that the Dynamic schema could not retrieve the table structure ?
Last edited by ffwrude (2012-06-01 10:50:50)
I can't right now (cause it's running) i deleted the empty tables and it works fine with the original job. But i have 22Gb to copy. So... i'll send it later.