Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
rp2018
Creator
Creator

AdditionaParams for MySQL connection

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

 

 

Labels (3)
1 Reply
jeoste
Creator II
Creator II

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"0683p000009M7bd.png

 

It worked for me, using a Wamp with MySQL 5.7.24

 

EDIT : here's a useful link Multiple additional parameters