topic Re: PostgresSql JDBC Output Component Isues - Double Quote on Table and Column Attibutes in Talend Studio

PostgresSql JDBC Output Component Isues - Double Quote on Table and Column Attibutes

Anonymous — Tue, 12 Mar 2019 12:25:00 GMT

Currently, I am experiencing some issues on how the JDBC output component handles double quotes.

As you can see in the picture attached, at the last step of the job, the output component creates the insert statements properly, however, it fails to decorate properly the attributes in the SQL statement - in my case, all attributes in the table schema are uppercase (table & column names). I have added double quotes to all attributes in the statement and run it manually against PostgresSql and works fine!

Could anyboday advise where the issue is or point to another message/ticket were this has been addressed?

Best regards and thanks in advance.

Notice: I am using JDBC components to make the job platform agnostic. I have switched the JDBC database type in the connection component to Oracle and it works fine. Thereby, I am only facing this issue with PostgresSql.

Re: PostgresSql JDBC Output Component Isues - Double Quote on Table and Column Attibutes

vapukov — Tue, 12 Mar 2019 13:15:00 GMT

Hi,

I thought - you not find there solution for your problem

at least tPostgreSQLOutput handle cases proper,

but univeersal JDBC - it is very wide component, some databases require "", some [], some other simbols

if you want to use exactly tJDBCxxx instead of tPosrtgreSQLxxx you could use tSQLRow with prepared statements, but it also not useful

Re: PostgresSql JDBC Output Component Isues - Double Quote on Table and Column Attibutes

Anonymous — Tue, 12 Mar 2019 13:33:57 GMT

Dear Vakupov,

Thanks for your prompt reply.

Pardon my ignorance, the statements are prepared in Talend an executed against the target DB. I can see that is the case if I choose a different data provider, Oracle for instance. The insert statements are decorated properly with double quotes.

Kind regards