topic Re: [resolved] Error in tMysqlconnection in Talend Studio

[resolved] Error in tMysqlconnection

Anonymous — Fri, 27 Dec 2013 05:51:56 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Fri, 27 Dec 2013 06:27:48 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Fri, 27 Dec 2013 07:03:29 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Fri, 27 Dec 2013 07:36:31 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Fri, 27 Dec 2013 12:08:41 GMT

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?

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 02:23:58 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 06:58:52 GMT

Hi,

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 07:02:14 GMT

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.

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 07:14:06 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 07:30:04 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 08:04:41 GMT

Hi,
I have made a testing on Talend Open Studio for 5.3.1. Everything is OK for me. I suspect something wrong with your MySql DB.
Could you use other tool to connect it directly to see if it is working?(such as, DB Visualizer).
Best regards
Sabrina

Re: [resolved] Error in tMysqlconnection

Anonymous — Mon, 30 Dec 2013 09:28:48 GMT

Hi Sabrina,
Thanks for your quick replay...

Re: [resolved] Error in tMysqlconnection

Anonymous — Tue, 31 Dec 2013 02:34:27 GMT

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

Re: [resolved] Error in tMysqlconnection

Anonymous — Tue, 31 Dec 2013 09:39:48 GMT

Hi sabrina,
That issue is resolved now. Previously i am using only one port to connect to the My sql like 8180 and now i got that it requires two ports, one to connect to the SQL Db with port no.like 3306 and one to connect to the Talend server like 8180.
Now it is working fine.
Thank you.

Re: [resolved] Error in tMysqlconnection

Anonymous — Thu, 02 Jan 2014 04:07:09 GMT

Hi,
Thanks for your feedback. Feel free let me know if there any further help we can provide.
Best regards
Sabrina