topic AdditionaParams for MySQL connection in Talend Studio

AdditionaParams for MySQL connection

rp2018 — Sat, 16 Nov 2024 04:58:47 GMT

Creating a database connection for MySQL db and need AdditionParams for

LoginTimeout, ConnectionRetry and ConnectionRetryDelay.

Currently, I've setup like this but it is throwing error that a value should be true or false.

noDatetimeStringSync=true;LoginTimeout=30;ConnectionRetryCount=10;ConnectionRetryDelay=10

Re: AdditionaParams for MySQL connection

jeoste — Tue, 13 Aug 2019 21:50:51 GMT

Hello,
How did you define the additional_parameters inside your component / metadata file ?
Instead of using ";" try to do this by replacing ";" with "&" in the "Additional JDBC Parameters"

"noDatetimeStringSync=true&LoginTimeout=30&ConnectionRetryCount=10&ConnectionRetryDelay=10"

It worked for me, using a Wamp with MySQL 5.7.24

EDIT : here's a useful link Multiple additional parameters