Update JDBC¶
This node update the data to selected columns.
Type¶
transform
Class¶
fire.nodes.save.NodeUpdateJDBC
Fields¶
Name |
Title |
Description |
|---|---|---|
primaryKeyColumn |
Primary Key Column |
Key column name in table |
updateColumn |
Update Column |
Update column name in table |
table |
DB Table |
The JDBC table to write to |
connection |
Connection |
The JDBC connection to connect |
Details¶
Update JDBC Node Details¶
This node update the data to selected columns.
Parameters to be set:¶
OUTPUT STORAGE LEVEL: Keep this as DEFAULT.
PRIMARY KEY COLUMN: Specify the column(s) that uniquely identify rows in the database table, Select the primary key column(s) from the “Available” list and move them to the “Selected” list.
UPDATE COLUMN: Specify the column(s) that you want to update in the database table, Select the columns to be updated from the “Available” list and move them to the “Selected” list.
DB TABLE: Specify the name of the database table where data will be updated.
CONNECTION: Select the desired database connection to use.
Examples¶
Update JDBC Node Examples¶
Example of Updating Columns¶
PRIMARY KEY COLUMN: customer_id
UPDATE COLUMN: (email_address,last_login_date),This configuration would update the email_address and last_login_date for records in the database table, matching rows based on their customer_id.
DB TABLE: customers
CONNECTION: MY_POSTGRES_DB, This configuration would update the email_address and last_login_date for records in the customers table using the MY_POSTGRES_DB connection.