JDBC Connector

JDBC Connector

JDBC target operations in synchronization tasks

JDBC target operations in
synchronization
tasks

You can perform insert, update, upsert, and delete operations on a JDBC target. Configure the field mapping based on the target operation.
When you map the primary key field, the
synchronization
application can identify the records to insert, update, upsert, or delete.
When you run a task with the insert, update, or upsert operations to a JDBC target, map the primary key field and all other fields that you want to update.
When you run a task with the delete operation on a JDBC target, map the primary key field only. You do not need to map any other fields.
When you write to a Postgres JDBC target field of the bit data type, the
synchronization
task fails due to a PostgreSQL and JDBC limitation.
If you create a
synchronization
task with a JDBC target object and a specified precision value (for example, 6,3) for decimals, if the target contains a decimal field with a precision that exceeds the specified precision value, the task fails. This is due to a Derby limitation.

0 COMMENTS

We’d like to hear from you!