When trying to get the JDBC link going I am unable to read the TIMESTAMP Mysql type. Getting
Couldt read from database: Cannot convert value "00-0000 00:00:00" to from column 6 to TIMESTAMP.
But I have TIMESTAMP=0, (and tried TIMESTAMP=9) which I thought told Weka to treat a timestamp like a string?
Any suggestions?
The database setting are:
# Database settings for MySQL 3.23.x, 4.x
#
# url: http://www.mysql.com/
# jdbc: http://www.mysql.com/products/connector/j/
# author: Fracpete (fracpete at waikato dot ac dot nz)
# version: $Revision: 1.3 $
# JDBC driver (comma-separated list)
jdbcDriver=org.gjt.mm.mysql.Driver
# jdbcDriver=com.mysql.jdbc.Driver
# database URL
# jdbcURL=jdbc:mysql://localhost:3306/db
jdbcURL=jdbc:mysql://localhost:3306/db
# specific data types
# string, getString() = 0; --> nominal
# boolean, getBoolean() = 1; --> nominal
# double, getDouble() = 2; --> numeric
# byte, getByte() = 3; --> numeric
# short, getByte()= 4; --> numeric
# int, getInteger() = 5; --> numeric
# INT, getInteger() = 5; --> numeric
# INT., getInteger() = 5; --> numeric
# long, getLong() = 6; --> numeric
# gloat, getFloat() = 7; --> numeric
# date, getDate() = 8; --> date
# text, getString() = 9; --> string
#Text
CHAR=0
TINYTEXT=0
TEXT=0
VARCHAR=0
LONGVARCHAR=0
BINARY=0
VARBINARY=0
LONGVARBINARY=0
BLOB=0
MEDIUMTEXT=0
MEDIUMBLOB=0
LONGTEXT=0
LONGBLOB=0
#Number types
BIT=1
NUMERIC=2
DECIMAL=2
FLOAT=2
DOUBLE=2
TINYINT=3
SMALLINT=4
#SHORT=4
SHORT=5
INTEGER=5
INT=5
INT_UNSIGNED=5
MEDIUMINT=5
BIGINT=6
LONG=6
#Data Types
REAL=7
DATE=8
TIME=8
TIMESTAMP=0
DATETIME=0
#mappings for table creation
CREATE_STRING=VARCHAR(8000)
CREATE_INT=INT
CREATE_DOUBLE=DOUBLE
#database flags
checkUpperCaseNames=false
setAutoCommit=true
createIndex=false
#flags for loading and saving instances using DatabaseLoader/Saver
nominalToStringLimit=50
idColumn=auto_generated_id
# other options
CREATE_DOUBLE=DOUBLE
CREATE_STRING=TEXT
CREATE_INT=INT
checkUpperCaseNames=false
checkLowerCaseNames=false
checkForTable=true