Talend community forum / SQL Query with parameters

dosy07 · 2010-04-09 09:48:27

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

shong · 2010-04-09 09:52:08

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

dosy07 · 2010-04-09 10:17:43

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.

shong · 2010-04-09 14:45:17

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

dosy07 · 2010-04-09 15:52:04

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

emaxt6 · 2010-04-10 13:34:55

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.

Last edited by emaxt6 (2010-04-10 13:35:29)

Announcement

Unanswered posts

#1 2010-04-09 09:48:27

SQL Query with parameters

#2 2010-04-09 09:52:08

Re: SQL Query with parameters

#3 2010-04-09 10:17:43

Re: SQL Query with parameters

#4 2010-04-09 14:45:17

Re: SQL Query with parameters

#5 2010-04-09 15:52:04

Re: SQL Query with parameters

#6 2010-04-10 13:34:55

Re: SQL Query with parameters

Board footer