topic Re: sql query in tJavaRow in Talend Studio

sql query in tJavaRow

Anonymous — Fri, 11 Oct 2013 10:13:41 GMT

hello ,
how to query metadata stored in talend to his request of a component TjavaRow.
thank you in advance .

Re: sql query in tJavaRow

Anonymous — Fri, 11 Oct 2013 11:25:52 GMT

Hi
Sorry, I don't fully understand what you want to do? Do you want to execute a query which have been defined in Metadata?
Shong

Re: sql query in tJavaRow

Anonymous — Fri, 11 Oct 2013 15:21:31 GMT

Hi ,
Yes, I want to execute a query that was defined in the metadata but inside tJavaRow.

Re: sql query in tJavaRow

Anonymous — Sat, 12 Oct 2013 02:19:33 GMT

tJavaRow is not a general DB component, you are unable to use a repository query on tJavaRow, you have to input manually the query. For better management of your query, you can define a context variable for the query and use the context variable on tJavaRow, if the query changes, you just need to modify the context variable.
Shong

Re: sql query in tJavaRow

Anonymous — Sun, 13 Oct 2013 12:58:38 GMT

Why using tJavaRow to execute a query? You can use your query stored in the metadata in a much better way in any t<DB>Input component by using a repository based query instead of build-in query.

Re: sql query in tJavaRow

Anonymous — Mon, 14 Oct 2013 10:24:50 GMT

Hi ,
thank you shong and jlolling for responding and for the interest you have shown in my problem. and for your suggestion I will try to implement it.