topic Re: tJavaRow to Database table using dynamic shcema in Talend Studio

tJavaRow to Database table using dynamic shcema

Anonymous — Mon, 16 Jul 2012 15:33:26 GMT

Hi All,
I am proceesing 9 columns with tJavaRow componet.
I want to send 9 columns data to database table as dynamic schema.
can you guys please help me out on this..
I am attached sample job over here.
Thanks
Ranga.

Re: tJavaRow to Database table using dynamic shcema

Anonymous — Tue, 17 Jul 2012 11:32:32 GMT

Pedro -
is there any other way to acheive this.
Thanks
Ranga

Re: tJavaRow to Database table using dynamic shcema

Anonymous — Tue, 17 Jul 2012 12:15:49 GMT

HI Pedro,
I have seen some posts about dynamic schema. Could you please file below attached post:
Hi
The components which support dynamic schema are noted in a text file called supportDynamic.txt, which is located in <Talend studio install dir>\plugin\org.talend.core.tis_x.x.x.rxxxxx.jar. Such as, for example: org.talend.core.tis_5.0.1.r74687.jar.
To open the supportDynamic.txt file and view the supported components, simply follow these steps:
Unzip the org.talend.core.tis_x.x.x.rxxxxx.jar jar.
Go to <org.talend.core.tis_x.x.x.rxxxxx directory path>\resources and open the supportDynamic.txt file.
The list are:
tFileInputDelimited
tFileOutputDelimited
tAccessInput
tAS400Input
tDBInput
tDB2Input
tEXAInput
tFirebirdInput
tGreenPlumInput
tHSQLDBInput
tIngresInput
tInformixInput
tJavaDBInput
tJDBCInput
tLDAPInput
tMaxDBInput
tMysqlInput
tMSSqlInput
tNetezzaInput
tOracleInput
tPostgresqlInput
tPostgresPlusInput
tParAccelInput
tSQLiteInput
tSasInput
tSybaseInput
tVectorWiseInput
tVerticaInput
tTeradataInput
tJava
tJavaFlex
tJavaRow
tLogRow
tMap
tOracleOutput
tMysqlOutput
tMSSqlOutput
tPostgresqlOutput
tAS400Output
tDB2Output
tInformixOutput
tSybaseOutput
tTeradataOutput
tAggregateRow
tSortRow
tFilterRow
tWriteDynamicFields
tExtractDynamicFields
and the list will more and more long in the future.
Best regards
Shong

Re: tJavaRow to Database table using dynamic shcema

Anonymous — Tue, 17 Jul 2012 12:56:07 GMT

is based on above list tJavaRow component supports dynamic schema?

Re: tJavaRow to Database table using dynamic shcema

Anonymous — Wed, 18 Jul 2012 03:42:01 GMT

Hi
You might create a job as the following image with dynamic schema feature.
What I mean above is that if you want to code in tJavaRow and manipulate input_row.
It would tell you that you can't convert it from String, for example, to Dynamic.
That's why I say the tJavaRow can't support dymanic schema.
It can only pass values of dynamic column.
Regards,
Pedro