topic ELT Map queries : compilation error with quotes in Talend Studio

ELT Map queries : compilation error with quotes

Anonymous — Thu, 30 Jun 2016 09:19:06 GMT

Hi,
I'm currently facing a problem with the tELTMap component of Talend. I'm using ELT JDBC components for Oracle databases.
I've created tables in my Oracle database with quotes and i want Talend to match case. So, I've added \" at the beginning and the end of the dbColumn in the schemas. However, if I chain two tELTMap, the query created by the second one contains compilation errors. The main problem is that double quotes aren't escaped a second time.
I've created a simple example to show you the problem. I've added two tELTJDBCInput for clients and their amout stats.
Then, i linked clients with a tELTMap component and did a 1 for 1 mapping.
I've linked another tELTMap with the previous one and sales statistics.
Then i linked the last one with a tELTJDBCOutput.

When i looked in the code generated, i can see and error in the query generated.

Any solution ?

Re: ELT Map queries : compilation error with quotes

Anonymous — Thu, 30 Jun 2016 15:58:11 GMT

Hi
I tested and got the same issue, can you please report a bug on our bugtracker? However, I don't get this error If I use tELTOracle... components.
Regards
Shong

Re: ELT Map queries : compilation error with quotes

Anonymous — Fri, 01 Jul 2016 11:00:27 GMT

Hi,
Thanks for the reply. I've reported the bug at https://jira.talendforge.org/browse/TDI-36791 .
I need to use the tELTJDBC... components to be as much generic as possible.

Regards