ODI Error 'oracle.odi.runtime.agent.ExecutionException: Communications link failure' When Testing Connection to MySQL Technology (Doc ID 2294027.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator 11.1.1.6 or higher, testing a Data Source connection to a MySQL database fails with both the Local (No Agent) and a remote J2EE Agent, and the following error is displayed:

2017-07-21 11:18:41.929 ERROR ODI-1131 Agent OracleDIAgent encountered an error: 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.
2017-07-21 11:18:41.930 ERROR oracle.odi.runtime.agent.ExecutionException: 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 oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:144)
  at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
  at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)
  at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
<...snip...>

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms