i have some problems with the installation of jdbc.
This is what i've done:
i've installed:java, apache 2.2, mysql Server 5.1, phpmyadmin, weka-3-6
i've downloaded: jdbc driver and i copied it in weka-3-6
i've exctracted the DatabaseUtils.props file from weka,and i edited it in this way:
# The comma-separated list of jdbc drivers to use
# The url to the experiment database
and i copied it in weka-3-6
i edited the classpath: C:\Program Files\Weka-3-6\weka.jar;C:\Program Files\Weka-3-6\mysql-connector-java-5.1.12-bin.jar
and the path: ;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\Program Files\Weka-3-6;
when i open the Explorer in weka, click 'open DB', in users insert username and password, click connect and it writes:
connecting to:jdbc:mysql://localhost:3306/db_esempio = true
but when i click on 'ok',
Problem connecting to database: no suitable driver found for
Coul you help me?
It sounds like the classpath is the issue here. Assuming your modified DatabaseUtils.props and mysql-connector-java-5.1.12-bin.jar are in C:\Program Files\Weka-3-6, can you open a terminal and try:
1) change directory to C:\Program Files\Weka-3-6
2) java -cp weka.jar;mysql-connector-java-5.1.12-bin.jar weka.gui.GUIChooser
thanks for reply
If i do what you say, weka opens, but then, if i open weka's explorer and i try to connect to the db, it doesn't work
what could i doin you opinion?
thank you for your attention
It still sounds like a classpath problem. Are you sure that the mysql jar file is in the Weka-3-6 directory when you start weka with java -cp weka.jar;mysql-connector-java-5.1.12-bin.jar?
If i look in the weka-3-6 directory i see the mysql-connector-java-5.1.12-bin.jar...
What could be the problem in your opinion?
One last question: did you actually enter an SQL query in the "Query" part of the SQL-Viewer dialog after connecting successfully? If there is no query entered, then I get the same error message that you got (a little confusing I admit :-)) Note that you actually have to execute the query by pressing the "Execute" button before you click "OK" at the bottom of the dialog.
oh Mark!!!i'm so wimp!!!
you are right!!!I hadn't execute the query by pressing the "Execute" button before clicking "OK" at the bottom of the dialog.
But now...i have another error:
Couldn't read from database:
Unknown data type:INT.Add entry in weka/experiment/DatabaseUtils.props.
If the type contains blanks either escape them with a blackslash or use underscores instead of blanks
i read several treads about this error but still cannt find out what is wrong
Could you help me?
be patient, please i 'm so confused
Thank you for all!!
I solved my problems!!
thank you for your suggestions!!
you are the best!