When I have DatabaseExampleSetWriter with overwrite_mode set to "overwrite" it works correctly. However, if I have overwrite_mode set to "append" or "overwrite first, append then", I get the following error:
PatternSyntaxException caught:
Unclosed character class near index0
[
^
Is this a bug, or user error?
UPDATE: This actually doesn't appear to be related to appen/overwrite, but rather writing nominal values to a database.
This causes an error:
<operator name="Root" class="Process" expanded="yes">
<operator name="NominalExampleSetGenerator" class="NominalExampleSetGenerator">
<parameter key="number_of_attributes" value="1"/>
<parameter key="number_of_values" value="3"/>
</operator>
<operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
<parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/>
<parameter key="database_url" value="jdbc:sqlserver:xxxxxx"/>
<parameter key="overwrite_mode" value="overwrite"/>
<parameter key="password" value="xxxxxx"/>
<parameter key="table_name" value="rm_test"/>
<parameter key="username" value="xxxxxx"/>
</operator>
</operator>
This one doesn't. The only change is now I'm using ExampleSetGenerator to produce all numeric data.
<operator name="Root" class="Process" expanded="yes">
<operator name="ExampleSetGenerator" class="ExampleSetGenerator">
<parameter key="target_function" value="sum"/>
</operator>
<operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
<parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/>
<parameter key="database_url" value="jdbc:sqlserver:xxxxx"/>
<parameter key="overwrite_mode" value="overwrite"/>
<parameter key="password" value="xxxxx"/>
<parameter key="table_name" value="rm_test"/>
<parameter key="username" value="xxxxx"/>
</operator>
</operator>
Thanks,
Keith