topic Re: How can add extra jdbc settings to a MySQL connection? in Talend Studio

How can add extra jdbc settings to a MySQL connection?

Anonymous — Sat, 16 Nov 2024 13:23:29 GMT

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.

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

Anonymous — Fri, 18 Jun 2010 16:00:01 GMT

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

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

Anonymous — Fri, 18 Jun 2010 16:09:26 GMT

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.

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

Anonymous — Tue, 13 Jul 2010 23:28:00 GMT

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

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

Anonymous — Wed, 14 Jul 2010 11:06:08 GMT

hi gustavof,

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

I think it's the right question
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

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

Anonymous — Fri, 04 Jul 2014 10:53:46 GMT

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 ....