Hi, I just started using KNIME and since this is the first time i’m using a mining tool, i really need your help!
I use Wamp server, with php and Apache and i uploaded my databse in phpmyAdmin (ver 126.96.36.199).
In order to connect with my database through knime i use the node Database REader. I tried to import the JDBC MySql Driver but when i tried to load it through that node, i got an error message that the .jar file was not a valid xml file.
Anyway, after several restarts i finally got some new options for the database driver (in the database reader node) and i use this one: com.mysql.jdbc.Driver. Then for my database url the only 2 options that gave me a more encouraging result are these: 1)jdbc:mysql://@localhost:80/database_name and 2)jdbc:mysql://@phpmyadmin:80/database_name.The message that i take after using it is the one below and in the end i cannot connect with my database:
WARN Database Reader java.sql.SQLException: 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.
If I dont use the “@” i get a TimeoutException error… Can anyone tell me what i’am doing wrong?
I use knime-2.1.2-win32.win32.x86 with alll the available updates.