You are not logged in.
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.
Sorry. I can't point out what causes null query now.
Please send me an email and attach your job.
Ok. So now. How can i tell him to not try to do it with empty tables ?
Yes. That may be the root reason.
But I don't know what cause null query...
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 ?
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?
Hum.. ok but if it work on your version. How can i make a workaround ? Because i don't want to run 150times the job with just the table name changing.
Yes. I have used dynamic schema.
Maybe this is related to BLOB column.
I will test it again.
Did you put DYNAMIC schema and have like 3tables with different structures ?
Table2 var(varchar-255), tatayoyo(id 25),trululu(int 20)
Sorry. My fault. I should type TIS.
In fact, I have created a job as the following image.
I didn't get a NPE exception....
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"))+""
Yes. I know it's TIS.
But I can't confirm whether it is a bug. The info is limited.
I'm on TIS 4.2.2 not TOS.
Which version of TIS do you use?
I test it under TIS 5.0.1 and didn't get NPE exception.
Maybe I miss some detail.
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