topic Re: programatically changing schema and properties of components` in Talend Studio

programatically changing schema and properties of components`

Anonymous — Mon, 04 Jun 2018 15:47:19 GMT

Can I, using tJava, change the schema or other properties of tJDBCRow?

I read a table from tJDBCInput with dynamic column (since I only know the query and connection sting at run time). I need to either insert this data in another table (using some output component) or run a procedure/generic query using the returned fields (which in this case will return only one row).

Since the Row components (and also tJDBCOutput) cant use the dynamic column I need to read it using tJava and the fix the other components some how.

Any solution for this?

Thanks

Re: programatically changing schema and properties of components`

fdenis — Mon, 04 Jun 2018 16:01:59 GMT

you ca do this it' working fine.

you can also create insert our update query dynamically to create/update your table first.

regards,

Francois

Re: programatically changing schema and properties of components`

Anonymous — Tue, 05 Jun 2018 07:34:34 GMT

Thanks for the answer.

Do you happen to have any sample code?

Thanks!

Re: programatically changing schema and properties of components`

fdenis — Tue, 05 Jun 2018 08:07:43 GMT

I'm sorry I cannot send you samples but it's working I already done it two time.