...
- connection: The name of an existing database connection (see Database Feature how to create one)
Or: - type: The JDBC connection type (e.g. mysql)
- db: The Database to access
- user: The username for the database
- password: The password for the user
- host:The hostname of the database
- port: The port of the database connection
Or: - jdbc: The jdbc connect string
- table: The table to write to
- drop: Should the table be dropped and recreated
- truncate: Should existing elements be dropped before wrinting to the table (but keeping the Table)
- BatchSize: How many elements should be written, before they are commited to the database (default is 10)
- BatchTimeout: How long should the system wait (in ms) even if not BatchSize elements are buffer. This is useful for cases where the datarate is not constant. Default is 0, i.e. no timeout, wait for ever. If the query the closed the batch will be written also.
Example
can be found under Database Feature