Synopsis
Writes the values of all examples to a single table in a database.
Description
This operator writes an ExampleSet into an SQL database. The user can specify the database connection and a table name. Please note that the table will be created during writing if it does not exist.
The most convenient way of defining the necessary parameters is the configuration wizard. The most important parameters (database URL and user name) will be automatically determined by this wizard. At the end, you only have to define the table name and then you are ready.
This operator only supports the writing of the complete example set consisting of all regular and special attributes and all examples. If this is not desired perform some preprocessing operators like attribute or example filter before applying this operator.
Input
- input: expects: ExampleSet
Output
- through:
Parameters
- define connection: Indicates how the database connection should be specified.
- connection: A predefined database connection.
- database system: The used database system.
- database url: The URL connection string for the database, e.g. 'jdbc:mysql://foo.bar:portnr/database'
- username: The database username.
- password: The password for the database.
- jndi name: JNDI name for a data source.
- table name: A database table.
- overwrite mode: Indicates if an existing table should be overwritten or if data should be appended.
- set default varchar length: Set varchar columns to default length.
- default varchar length: Default length of varchar columns.
- add generated primary keys: Indicates whether a new attribute holding the auto generated primary keys is added to the result set.
- db key attribute name: The name of the attribute for the auto generated primary keys