Hi,
I am trying to use the Data Writer node, but a problem always pop up:
ERROR Database Reader 0:614:605:749 Execute failed: 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.
Observations:
1) I am using a MAC OS.
2) I installed MAMP and created a Mysql server.
3) The config of the server is:
Host | localhost |
---|---|
Port | 8889 |
User | root |
Password | root |
Socket | /Applications/MAMP/tmp/mysql/mysql.sock |
4) I followed the tutorial presented here: https://tech.knime.org/database-documentation and installed the "com.mysql.jdbc.Driver"
5) The screenshot of my Data Writer is attached.
If the file is broken, I did config like this:
Databse Driver: com.mysql.jdbc.Driver
Databse Url: jdbc:mysql://localhost:8889/Deputados
Username:root
password:root
Table name: Teste
6) The screenshot of my workflow is attached.
Thanks,
Eduardo.