databaseexamplesource
Hi! I tried to run decision tree operator with data that I extract from a mysql database, but rapid throw this error:
Root[0] (Process)
+- DatabaseExampleSource[0] (DatabaseExampleSource)
+- DecisionTree[0] (DecisionTree)
P May 13, 2009 10:24:46 AM: [Fatal] OutOfMemoryError occured in 1st application of DatabaseExampleSource (DatabaseExampleSource)
P May 13, 2009 10:24:46 AM: [Fatal] Process failed: Java heap space
Root[1] (Process)
here ==> +- DatabaseExampleSource[1] (DatabaseExampleSource)
+- DecisionTree[0] (DecisionTree)
How can I fix this?If it's possible to do so?
This is my .xml file:
<?xml version="1.0" encoding="windows-1252"?>
<process version="4.2">
<operator name="Root" class="Process" expanded="yes">
<operator name="DatabaseExampleSource" class="DatabaseExampleSource">
<parameter key="database_url" value="jdbc:mysql://......"/>
<parameter key="password" value="......="/>
<parameter key="query" value="SELECT `t_calles`.`idCalle` AS `t_calles__idCalle`, `t_calles`.`CodPostal` AS `t_calles__CodPostal`, `t_calles`.`Calle` AS `t_calles__Calle`, `t_calles`.`Calle_resum` AS `t_calles__Calle_resum`, `t_calles`.`otro_id` AS `t_calles__otro_id`, `t_calles2`.`id` AS `t_calles2__id`, `t_calles2`.`calle` AS `t_calles2__calle`, `t_municipios`.`idMunicipio` AS `t_municipios__idMunicipio`, `t_municipios`.`CodProv` AS `t_municipios__CodProv`, `t_municipios`.`CodPostal` AS `t_municipios__CodPostal`, `t_municipios`.`Municipio` AS `t_municipios__Municipio`, `t_provincias`.`CodProv` AS `t_provincias__CodProv`, `t_provincias`.`Provincia` AS `t_provincias__Provincia` FROM `t_calles`, `t_calles2`, `t_municipios`, `t_provincias`"/>
<parameter key="username" value="xxx"/>
</operator>
<operator name="DecisionTree" class="DecisionTree">
<parameter key="keep_example_set" value="true"/>
</operator>
</operator>
</process>
the database codpost is 9.23 MB or close.
thanks!!!!