PDA

View Full Version : SQL 2005, Numeric Data Type



benja
01-26-2008, 02:29 PM
Hi guys,

I am connecting SQL 2005 with Weka. I have changed the databaseutils.prop file and connect to the database fine.

My issue here is that I have a numeric input column that is a datatype not recognized initially by Weka. I have tried inserting in the same file the parameter numeric=9 or NUMERIC=9, I can not find any documentation on this.

Any comments on how to deal with this issue.

I am using a DSN connection.

Regards,

Ben

Mark
01-28-2008, 06:25 PM
Hi,

Do you know the name of the column type being returned from the JDBC driver for this input column? If it is NUMERIC/numeric then you want to map this to value 2 (so that the values are retrieved as doubles from the driver).

See this Wiki page for more info:

http://weka.sourceforge.net/wiki/index.php/Databases

Cheers,
Mark.