topic Re: I can not connect my sql server with talend in Talend Studio

I can not connect my sql server with talend

_AnonymousUser — Sat, 16 Nov 2024 12:56:01 GMT

I want to create a database connection in the metadata section, so I want to connect to my mysql database in my server but Talend always displays me this message when I push the CHECK button:
Connection failure. You must change the Database Settings.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The parameters are all right, server name, user, password, port number (3306 default port), database name, etc... but I can't connect the server. Any help would be useful.
Thanks.

Re: I can not connect my sql server with talend

Anonymous — Mon, 09 May 2011 15:22:19 GMT

Is the Database Server definately running?
The Communications link failure means that it could not connect to the server.
Also recheck connection settings to make sure they are definately correct (Maybe you connect to your database on another port?)

Re: I can not connect my sql server with talend

_AnonymousUser — Mon, 09 May 2011 16:22:46 GMT

The database server is running perfectly and the port is correct. I think the failure is because some firewall is blocking some ports from my jobplace. In localhost I connected to a mysql test db without problems.
Thanks.

Re: I can not connect my sql server with talend

Anonymous — Mon, 09 May 2011 17:05:42 GMT

if you have MySQL server on u r local machine.. then you should be able to connect it.
try with IP address. 127.0.0.1

Re: I can not connect my sql server with talend

_AnonymousUser — Tue, 10 May 2011 08:32:55 GMT

I can connect to my machine, with 127.0.0.1 or with localhost. Thanks anyway

Re: I can not connect my sql server with talend

janhess — Tue, 10 May 2011 10:03:03 GMT

In my experience this is ususlly a permissions problem. Can you connect manually to the database from your machine using the same credentials?

Re: I can not connect my sql server with talend

_AnonymousUser — Tue, 10 May 2011 12:11:48 GMT

Yes, if I type the mysql server URL in a web browser I can access to the DB, but not from Talend creating a new connection.

Re: I can not connect my sql server with talend

Anonymous — Mon, 13 Jun 2016 06:53:40 GMT

Hi All,
Can any1 solve my query.
i want to read 80 million record from mysql and write into mysql.
But after 20 million reads it gave me could not create connection error.
.
.
2016-06-10 03:07:25;aAtDjY;kC202j;kC202j;BIOWISE_ETL_JOB;BW_Dbnsfp_SNP_Job_0;Default;6;Java Exception;tMysqlInput_1;com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.;1
can any1 ll provide solution for this?
Regards,
Anand Yadav