Make sure your entries for JDBC driver and database URL are similar to what are shown below.
In this example the server is localhost, the port is 1433, and the database is named MSSQLTips. Below the database URL entry there is a section that configures the data type mappings between WEKA and SQL Server.
Notice the database utility property files at the bottom of the following image.
We need to make several changes to the Database Utils.props file. Open the file Database Utils.props.mssqlserver2005 with a text editor and save as Database Utils.props to overwrite the existing Database Utils.props file.
In this example, the column Did Buy APersonal Equity Plan will be the class label in WEKA.
create table Bank Data ( Unique ID int identity(1,1) Primary Key, Age Range varchar(8) not null, Gender varchar(6) not null, Region varchar(10) not null, Income varchar(8) not null, Married varchar(3) not null, Number Of Children int not null, Is Car Owner varchar(3) not null, Has Savings Account varchar(3) not null, Has Current Account varchar(3) not null, Has Mortgage varchar(3) not null, Did Buy APersonal Equity Plan varchar(3) not null ) Now that the data is loaded into WEKA, you can take advantage of all of the available machine learning algorithms available to classify and cluster your data.
How to solve common problems with applying Cold Fusion updates (in 10 and above) Sung said: Hi Charlie -- I'd be grateful if you might want to comment on this? He's written nearly 100 articles for the Adobe CF Community Portal, CFDJ, Fusion Authority Quarterly Update, Adobe Dev Center, Community MX and more, as well as hundreds of blog entries.
A contributor to all 7 volumes of the CF10, 9, and 8 Web Application Construction Kit books by Ben Forta et al, he was also co-author of the Cold Fusion Anthology, CFMX Bible, and others.
Charlie's a certified Advanced CF Developer and Instructor for each release since CF 4, and he's presented nearly 100 talks to hundreds of developer conferences and user groups worldwide.
Also, please check out these tips on data mining in SQL Server Analysis Services on
Some content may be outdated--though not necessarily. Following onto my 2 previous entries related to updating JDBC drivers in CFMX 6 and 7, some readers may appreciate a little more help on the matter of determining just what version of the drivers they do now have installed.