topic How to get globalMap inside Java string to work with SQL component (tDBInput) in Talend Studio

How to get globalMap inside Java string to work with SQL component (tDBInput)

anna_t1 — Sat, 16 Nov 2024 00:52:11 GMT

Hi all,

I managed to use a Manual query inside my TDBInput, like this:

"SELECT

DISTINCT col1

'"+globalMap.get("start_dt")+"' as start_date

FROM table1;"

The problem is when I try to the same but by reading it from a file with tFileInputRaw->TFlowToterate->TDBinput with

globalMap.get("row2.content") inside. The globalMap doesn't get solved at runtime because it's inside a Java string. I've tried to escape it, done lots of single and double quotes combinations, but can't seem to find a way of this to work. It's just the globalMap that it's not being translated, since the query runs smoothly in the database.

How can I workaround reading from SQL file, when my SQL text contains globalMap inside?

My SQL file is the same as the above SQL but without the leading double quotes. Still, doesn't work.

Re: How to get globalMap inside Java string to work with SQL component (tDBInput)

hanghan — Wed, 06 Jan 2021 12:35:04 GMT

Could you please print the globalmap in the tjava, just before the database component?

Re: How to get globalMap inside Java string to work with SQL component (tDBInput)

madhukolli2003 — Wed, 06 Jan 2021 14:43:55 GMT

Hi @Ana Tavares ,

Can you try removing single quotes from this '"+globalMap.get("start_dt")+"'

Also can you try adding valid datatype ((String)globalMap.get("start_dt"))

Thanks & Regards,

Madhu Kolli

Re: How to get globalMap inside Java string to work with SQL component (tDBInput)

Prakhar1 — Thu, 07 Jan 2021 06:56:36 GMT

Can you try to use context instead of the global variable, and put the row2.content value in that context before proceeding to iteration ?