[resolved] Error in tMysqlconnection

[Anonymous]

Hi,
I am getting this error while running the job.
Help me out..
connecting to socket on port 3599
connected
connecting to socket on port 4936
connected
Exception in component tMysqlConnection_1
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.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)

To see the whole post, download it here

[Anonymous]

Hi,
Something wrong with your MySql DB connection. Is your MySql DB installed on local or server? The net-working is fine?
Is it working when you use studio Metadata to set up DB connection TalendHelpCenter: Setting up a database connection.
Best regards
Sabrina

[Anonymous]

Hi,
Thank you for the quick response.
I am trying to connect DB that is in server and net is working fine.
I tried in DBconnection is there Metadata repository but after clicking check button some log is coming like this
" com.mysql.jdbc.exception.jdbc4.communicationException:Communication link failure "
" The last packect sent successfully to the server was 0 milliseconds ago.The driver has not received any packet from the server"
do i need to place any jar file to get connect with Mysql..?

[Anonymous]

Hi,
What the talend studio build version are you using. I will take a testing for you to see if this issue repro.
Best regards
Sabrina

[Anonymous]

MySQL in the standard installation does not work over the network. You have to configure network access for your self. Did you checked the connection with a different tool (like MySQLWorkbench or SQuirrel) already?

[Anonymous]

Hi Dukeguru,
Is there any update for your issue?
Best regards
Sabrina

[Anonymous]

Hi,

I am using default version of talend that is customized version.
Thank you.

[Anonymous]

Hi jlolling,
I did't checked connection with any of those what u mentioned in the above.This is the first time i am using this talend to connect with DB in server using Tmysqlconnetcion component.
Thank you.

[Anonymous]

Hi,

I am using default version of talend that is customized version.

The latest open source one 5.4.1, 5.4.0 or 5.3.1?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I am using 5.3.1 version.
Thank you.