Cannot start Weka - getting error

Question

I have successfully installed Weka and need it to connect to our MS SQL Server. But when I start Weka I get the below error:

# java -Xmx1000M -jar weka.jar
---Registering Weka Editors---
Trying to add database driver (JDBC): jdbc.idbDriver - Error, not in CLASSPATH?

Where I can get a the .jar or lib files where I have only the below listed .jar files:

# find . -name "*.jar"
./weka.jar
./weka-src.jar
./remoteExperimentServer.jar
[weka-3-6-12]#

What else I need to install to run Weka successfully.

As per the comment below this is the content of my "weka/experiment/DatabaseUtils.props" file:

# grep -i idbDriver weka/experiment/DatabaseUtils.props

#jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver
#jdbcDriver=jdbc.idbDriver
#jdbcDriver=RmiJdbc.RJDriver,jdbc.idbDriver,org.gjt.mm.mysql.Driver,com.mckoi.JDBCDriver,org.hsqldb.jdbcDriver

Since every line starts with '#' that has jdbc.idbDriver I believe that these lines are comment. Am I correct in my understanding - also I believe that this warning / error which can be ignored.

But please let me know what changes I need to make to connect Weka to MS SQL Databases?

knb knb · Accepted Answer · 2015-04-20T08:56:20

To enable connectivity to MSSQL via weka, do this: (do this if you are on windows)

create a start script
create a DatabaseUtils.props file

Here is my startscript. Note how the $CP variable is set. This contains the full path to the jtds.jar file which contains the jdbc driver for MSSQL.

#!/bin/bash
WEKA_HOME=/opt/smallapps/weka-stable/weka
export WEKA_JAR=$WEKA_HOME/weka.jar
export PATH=$WEKA_HOME:$PATH
CP="/usr/share/java/:/opt/dbvis9/jdbc/jtds/jtds.jar:/opt/database/sqlite/sqlite-jdbc.jar:$WEKA_JAR"
echo "used CLASSPATH: $CP"
DIR=/opt/smallapps/weka-stable/data/
echo "changing to '$DIR'"
cd "$DIR"
export WEKA_HOME=$DIR
# start Weka's small GUIChooser window
java -cp $CP -Xmx500m weka.gui.GUIChooser &

This is the beginning my DatabaseUtils.props file, comments removed, stored at its default location. My full path: /opt/smallapps/weka/wekafiles/DatabaseUtils-mssql.props, linked to /opt/smallapps/weka/wekafiles/DatabaseUtils.props

jdbcDriver=org.sqlite.JDBC,net.sourceforge.jtds.jdbc.Driver

jdbcURL=jdbc:jtds:sqlserver://dbhost.mycompany.com:1433;DatabaseName=master

varchar=0
float=2
numeric=2
tinyint=3
int=5
bigint=6
nvarchar=9
nchar=9
char=9
decimal=2
bit=1
smallint=5
date=8

Here I have addded a screenshot with the buttons to click.

Note that there are no "Connection successful" messages. There will appear only yellow-triangle messages in the console window. (Red X - Icons if connection unsuccessful)

enter image description here

Connection URLs documentation by Microsoft here

Cannot start Weka - getting error

2 Answers