Output
JDBC Output
Writes the rows that reach it into an existing table of any database with a JDBC driver, in one transaction, and passes them on.
When to use it
Use it to load data into a database FlowDoo has no dedicated output for.
In a pipeline
Excel InputSelect ColumnsJDBC Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Update price list
- Target Table=informix.price_list
- Write Mode=Replace existing rows
| sku | price |
|---|---|
| A-100 | 12.5 |
| A-200 | 8 |
| sku | price |
|---|---|
| A-100 | 12.5 |
| A-200 | 8 |
Worth knowing
- Inserts are sent as a JDBC batch with auto-commit off, committed only when every statement worked.
- Names are used as typed; anything that is not a plain name is double-quoted (ANSI SQL).
- Previews never write.