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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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