Unable to connect MySQL data source


I'm unable to connect to MySQL data source .I'm able to connect to MySQL workbench but not in Incorta.

I'm getting below error message :


INC_005002001:Failed to Connect to [TestMySQL] due to [Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: " 3306"'.] with properties [[database, mysql], [user, incorta_user], [connectionPool, 30], [connection, jdbc:mysql:// giqr.asia.apple.com: 3306/incorta_db], [driver, com.mysql.jdbc.Driver]]

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Sandhya Rani -- it looks like you might have a whitespace before the 3306 per the error message.  Also looking at your JDBC connection string you may also have a whitespace before giqr.

  • Hi Dan,


    Even after removing space,I'm getting the error:


    INC_005002001:Failed to Connect to [TestMySQL] due to [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.] with properties [[database, mysql], [user, incorta_user], [connectionPool, 30], [connection, jdbc:mysql://giqr.asia.apple.com:3306/incorta_db], [driver, com.mysql.jdbc.Driver]]

    • Sandhya Rani That's progress.  Maybe port 3306 isn't open on between the servers.

    • It could also be that the user you're connecting as doesn't have privilege to connect to MySQL remotely.  Please check with your DBA.

Like Follow
  • 1 yr agoLast active
  • 4Replies
  • 53Views
  • 2 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!