0

Unable to connect MySQL data source

Hi,

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.

    Reply Like
  • 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]]

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

      Reply Like
    • 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.

      Reply Like
Like Follow
  • 3 mths agoLast active
  • 4Replies
  • 34Views
  • 2 Following