java - How to correctly map MySQL database to Weka values? -

i have database use generates instances weka machine learning approach:

query.setquery(string.format(sql_query, selectpartbuilder(tablename), tablename)); instances instances = query.retrieveinstances(); 

this works fine, problem of values interpreted nominal, though should numeric. had @ original data , don't why. since weka not offer nominaltonumeric filter, don't know next. looked @ databaseutils.props file , think mapping correct. missing?

i'm quite sure mapping problem, because when use csv file same values, values correctly interpreted numeric. bit=1 tinyint=1 bool=1 boolean=1 smallint=5 mediumint=5 int=5 integer=5 bigint=7 double=2 double_precision=2 float=2 int(11)=5