topic Re: Advanced Settings in tDBInput in Talend Studio

Advanced Settings in tDBInput

sushantk19 — Fri, 15 Nov 2024 23:13:26 GMT

Hello,

Is there a way I can define Multiple Additional JDBC parameters in tDBInput component in "

Advance settings" tab.

Please see the sreenshot attached.

By default it is

"noDatetimeStringSync=true". I want to add ""useSSL=false".

So i should have 2 parameters and not 1.

-"noDatetimeStringSync=true"

-"useSSL=false"

How can we do this?

rbk_tal — Fri, 11 Feb 2022 10:11:50 GMT

Maybe try adding them with a semicolon between the values ?

"noDatetimeStringSync=true;useSSL=false"

Haven't tried it - Just guessing...

gjeremy1617088143 — Fri, 11 Feb 2022 10:13:12 GMT

Hi, yes : "noDatetimeStringSync=true&useSSL=false"

send me love and kudos

sushantk19 — Fri, 11 Feb 2022 11:35:16 GMT

select count(*) from dm.fact_order

where to_char(load_at,'YYYY-mm-dd')='2022-02-11'

gjeremy1617088143 — Fri, 11 Feb 2022 13:22:52 GMT