You are not logged in.
Announcement
Unanswered posts
|
- Index
- » General questions
- » tMysqlOutput with Dynamic table name doesn't work
Post a reply
Topic review (newest first)
- ffwrude
- 2012-06-01 11:20:31
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.
- pedro
- 2012-06-01 11:17:22
Hi
Sorry. I can't point out what causes null query now.
Please send me an email and attach your job.
Regards,
Pedro
- ffwrude
- 2012-06-01 10:53:19
Ok. So now. How can i tell him to not try to do it with empty tables ?
- pedro
- 2012-06-01 10:51:02
Hi
Yes. That may be the root reason.
But I don't know what cause null query...
Regards,
Pedro
- ffwrude
- 2012-06-01 10:46:12
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
The row
table1
null
table2
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 ?
- pedro
- 2012-06-01 10:33:39
Hi
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?
Regards,
Pedro
- ffwrude
- 2012-06-01 10:12:17
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.
- pedro
- 2012-06-01 10:08:41
Hi
Yes. I have used dynamic schema.
Maybe this is related to BLOB column.
I will test it again.
Regards,
Pedro
- ffwrude
- 2012-06-01 10:06:43
Did you put DYNAMIC schema and have like 3tables with different structures ?
Like
Table1 id(int),id2(int)
Table2 var(varchar-255), tatayoyo(id 25),trululu(int 20)
Table3 troupoidou(Blob)
etc...
- pedro
- 2012-06-01 10:01:00
Hi
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....
Regards,
Pedro
- ffwrude
- 2012-06-01 09:57:48
You said TOS so that's why i clarified.
tMysqlInput1
Code:
" SHOW TABLES (Schema is set String named "table") "
tSetGlobalVar_1
Code:
Key "globaltable" => row1.table
tMysqlInput_3
Code:
SELECT
*
FROM
"+((String)globalMap.get("globaltable"))+"tMysqlOutput_1
Code:
Table is set to ""+((String)globalMap.get("globaltable"))+""- pedro
- 2012-06-01 09:45:30
Hi
Yes. I know it's TIS.
But I can't confirm whether it is a bug. The info is limited.
Regards,
Pedro
- ffwrude
- 2012-06-01 09:42:18
I'm on TIS 4.2.2 not TOS.
- pedro
- 2012-06-01 05:55:35
Hi
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.
Regards,
Pedro
- ffwrude
- 2012-05-31 15:20:32
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).
Anyway.
I have a Job that do :
tmysqlInput => "SHOW TABLE"
tFlowtoIterate
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
Code:
[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] disconnectedWhat am i doing wrong ?
EDIT :
- 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