JDBC Update Table

The new JDBC Update Table Post Processor is to be able to update the database table in the source repository. Users will be able to provide a SQL update statement (query) which will be run after the document has been written.

---

Configuration

• Authentication Connector: Authentication connection, usually the same one as the Repository Connection, that will allow the Post Processor to perform operation.

• Run For Each Document:

  • Yes: Will Run Post Processor for each Document.

  • No: Will only run once, ignoring documents.

• Condition: It will execute the task when the condition's result is 'true', 't', 'on', '1', or 'yes' (case-insensitive), or run on all conditions if left empty. This condition is evaluated for each document, determining whether the task should be executed based on the specified values.

• Stop Processing: If the condition results in 'true', 't', 'on', '1', or 'yes' (case-insensitive), no additional tasks will be executed for the current document being processed.

• Query: Database update query. To update the original Database table, write a SQL Update statement. The query supports the use of expression language.

  For example: See the Update SQL statement below. This is just an example. Each Query/Statement will need to be tailored to their specific Database Syntax.

  UPDATE TABLE_NAME SET LOCATION='/DOCS/SAMPLES' WHERE UNIQUE_ID_FIELD='#{RD.ID}';

  • Update table_name SET field_name=”value” where uniquie_id_field=”123”;

  • This will update the source database table’s fields with new provided values matching the row with given unique id

  • Note: Use it to execute Update SQL statements mostly. However, Insert and Delete sql statements can also run thus use it with caution.

Note:  Query fields will only take single quotes

---

Example

A very common requirement for a migration is to control a migration via a database table, which contains document location and other metadata to be migrated. A secondary part of that is to update the source database to record a status, new location, or other response metadata from the destination repository after the migration of each object.

---

API Keys

Key	Display Name	Type
use_condition	Check a condition before executing this task.	Boolean
task_condition	Condition	String
task_stop_proc	Stop Processing	Boolean
jdbc_query	Query	StringAREA

---