How can add extra jdbc settings to a MySQL connection?

Highlighted
One Star

How can add extra jdbc settings to a MySQL connection?

The environment that I am using is:

TOS 4.0.2 rev 43696
jdk1.6

I am experiencing sometimes a::::
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
I am trying to add things like: testOnBorrow=true;testOnReturn=false;testWhileIdle=true
I tried to add it to the Additional JDBC Parameters but I got an error. Any idea how can I do it? Any help will be appreciated.
Highlighted
One Star

Re: How can add extra jdbc settings to a MySQL connection?

Is it possible then to add the extra parameters in talend?
Highlighted
One Star

Re: How can add extra jdbc settings to a MySQL connection?

The com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure happen like I said in different jobs. In some runs, it doesn't happen other times it does. I think most of the times it happens when using the tMysqlRow.
Highlighted
One Star

Re: How can add extra jdbc settings to a MySQL connection?

You can add them with an & as a delimeter for the Additional JDBC Parameters
testOnBorrow=true&testOnReturn=false&testWhileIdle=true
Highlighted
One Star

Re: How can add extra jdbc settings to a MySQL connection?

hi gustavof,
In some runs, it doesn't happen other times it does ...

I think it's the right question Smiley Happy
What are the difference(s) between those working and the other one(s).
You can also create a metadata connection , test it before store it in the metadata db repository and use a tmysqlconnection at the start of your job (as a pre-job) .
Retrieve yours schema after that ...
Is it possible then to add the extra parameters in talend?

add parameters you need when you create your metadata connection (@screenshot) !
hope it help
regards
laurent
Highlighted
One Star

Re: How can add extra jdbc settings to a MySQL connection?

Hi ,
Im trying to setup db connection to vertica database (version 7.0) from talend 5.5 by passing additional JDBC parameters.
I created a meta data connection as showed in the first image and connection is successfully made .. but when i edit that meta data connection again it is not showing additional JDBC parameters as showd in the second image ...
Please suggest any thing to be modified ....

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog