topic Re: SQL Query with parameters in Talend Studio

SQL Query with parameters

Anonymous — Sat, 16 Nov 2024 13:28:07 GMT

Hi,
I create SQL query with parameters :
"select COUNT(*) from APPLICATIONFRC where APPLICATIONNAME = ? and APPLICATIONVERSION = ?"
How to pass parameters in tJavaDBInput with this query ?
tJavaDBInput do not accept row line, only iterate.

cdt,
Arnaud

Re: SQL Query with parameters

Anonymous — Fri, 09 Apr 2010 08:52:08 GMT

Hello
tFileInputDelimited--row1--tFlowToIterated--iterate--tJavaDBInput---tLogRow
on tJavaDBInput, type in the sql as:
"select COUNT(*) from APPLICATIONFRC where APPLICATIONNAME ="+(String)globalMap.get("row1.columnName1")+" and APPLICATIONVERSION ="+(String)globalMap.get("row1.columnName2")
Best regards
Shong

Re: SQL Query with parameters

Anonymous — Fri, 09 Apr 2010 09:17:43 GMT

I know this solution but you cant use it with query defined in "DB connections>Queries" because query is generic and you dont know the name of flow.

Re: SQL Query with parameters

Anonymous — Fri, 09 Apr 2010 13:45:17 GMT

Hello

"DB connections>Queries" because query is generic and you dont know the name of flow.

If you use the query from repository, you can change the query type from repository to built-in and edit the query.
Best regards
Shong

Re: SQL Query with parameters

Anonymous — Fri, 09 Apr 2010 14:52:04 GMT

Then there are no component to use Queries in repository with parameters like tMap ? its maybe a suggest, a new component for the futur

Re: SQL Query with parameters

Anonymous — Sat, 10 Apr 2010 12:34:55 GMT

Yeah, I agree, parametrizable queries would be a very welcomed and good feature in Talend, instead of going old-school with java string concatenation and escaping...
ie. a feature to accept queries that can use context or talend var seamlessly would be very good and provide clean syntax, ie.

"select field1, field2 from mytable where field1 = {context.var1} and field2 = {context.var2}"

I think would be easy to implement Talend side given the possibility to use very well known templating opensource engine like Freemarker.