One Star

sql query in tJavaRow

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

Re: sql query in tJavaRow

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: sql query in tJavaRow

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

Re: sql query in tJavaRow

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Seventeen Stars

Re: sql query in tJavaRow

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.
One Star

Re: sql query in tJavaRow

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.