<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: [resolved] Connection failure on mysqlinput in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/resolved-Connection-failure-on-mysqlinput/m-p/2359599#M124357</link>
    <description>I know this problem:
&lt;BR /&gt;
&lt;A href="http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure" rel="nofollow noopener noreferrer"&gt;http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure&lt;/A&gt;
&lt;BR /&gt;is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.</description>
    <pubDate>Thu, 24 Jul 2014 19:47:17 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2014-07-24T19:47:17Z</dc:date>
    <item>
      <title>[resolved] Connection failure on mysqlinput</title>
      <link>https://community.qlik.com/t5/Talend-Studio/resolved-Connection-failure-on-mysqlinput/m-p/2359598#M124356</link>
      <description>Hi, 
&lt;BR /&gt;I have a problem running jobs in command line. 
&lt;BR /&gt;I try to run a job which call other jobs (total of 12 jobs). When i run it using Talend Open Studio, it works, but when i run it in command line, i'm getting this error on a random mysqlinput : 
&lt;BR /&gt;---- 
&lt;BR /&gt;Exception in component tMysqlInput_11 
&lt;BR /&gt;com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 
&lt;BR /&gt;The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 
&lt;BR /&gt;Caused by: java.net.ConnectException: Connection timed out 
&lt;BR /&gt;---- 
&lt;BR /&gt;Problem is that I get this error on random MysqlInput (sometimes I get this on the first jobs, sometimes on the last, etc... ). 
&lt;BR /&gt;I saw that this could be resolved by increasing&amp;nbsp;"wait_timeout" and "interactive_timeout" =&amp;gt; they're already at "28800" so it should be okay. (?) 
&lt;BR /&gt;If you have any idea what could be resolve this, I would be glad to know it 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /&gt;&lt;/span&gt; 
&lt;BR /&gt;Thanks. 
&lt;BR /&gt;(Sry for my english, I'm doing my best).</description>
      <pubDate>Thu, 24 Jul 2014 16:00:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/resolved-Connection-failure-on-mysqlinput/m-p/2359598#M124356</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-07-24T16:00:44Z</dc:date>
    </item>
    <item>
      <title>Re: [resolved] Connection failure on mysqlinput</title>
      <link>https://community.qlik.com/t5/Talend-Studio/resolved-Connection-failure-on-mysqlinput/m-p/2359599#M124357</link>
      <description>I know this problem:
&lt;BR /&gt;
&lt;A href="http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure" rel="nofollow noopener noreferrer"&gt;http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure&lt;/A&gt;
&lt;BR /&gt;is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.</description>
      <pubDate>Thu, 24 Jul 2014 19:47:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/resolved-Connection-failure-on-mysqlinput/m-p/2359599#M124357</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-07-24T19:47:17Z</dc:date>
    </item>
  </channel>
</rss>

