Regarding Attribute Writing

ratheesan

Hi,

I am working with an Excel data.After applying cluster algorithms on it,I couldn't write the text data in to Access database.But it is allowing to write the "cluster" column.Whenever I am trying to write the text data an error displaying like "Database error occurred: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition" (I think the size of the data is too long).How can I solve this problem.Here I am attaching my process.

<operator name="Root" class="Process" expanded="yes">
    <operator name="ExcelExampleSource" class="ExcelExampleSource">
        <parameter key="excel_file" value="C:\Documents and Settings\ADMIN\Desktop\cl.xls"/>
        <parameter key="first_row_as_names" value="true"/>
    </operator>
    <operator name="Nominal2String" class="Nominal2String">
    </operator>
    <operator name="StringTextInput" class="StringTextInput" expanded="yes">
        <parameter key="vector_creation" value="TermOccurrences"/>
        <list key="namespaces">
        </list>
        <operator name="StringTokenizer" class="StringTokenizer">
        </operator>
        <operator name="EnglishStopwordFilter" class="EnglishStopwordFilter">
        </operator>
        <operator name="TokenLengthFilter" class="TokenLengthFilter">
        </operator>
        <operator name="PorterStemmer" class="PorterStemmer">
        </operator>
    </operator>
    <operator name="KMedoids" class="KMedoids">
    </operator>
    <operator name="AttributeFilter" class="AttributeFilter">
        <parameter key="condition_class" value="attribute_name_filter"/>
        <parameter key="parameter_string" value="comments"/>
    </operator>
    <operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
        <parameter key="database_system" value="ODBC Bridge (e.g. Access)"/>
        <parameter key="database_url" value="jdbc:odbc:conn"/>
        <parameter key="username" value="hello"/>
        <parameter key="password" value="NKBdJYTmaVo="/>
        <parameter key="table_name" value="jjj"/>
        <parameter key="overwrite_mode" value="overwrite"/>
    </operator>
</operator>

Thanks
Ratheesan

land

Hi,
use a real database and not Access if you want to store large texts. You might install the RapidMiner + Ingres bundle on a windows system for most convenient access on a database.

Greetings,
  Sebastian