db Property Group

The db property group includes the following properties that you can edit from the Properties table:

batch.update.timeout.retries

Defines the number of retries to attempt when batch mode timeouts occur.

Default: 5 (minimum is 0).

batch.update.timeout.seconds

Defines the interval to wait (in seconds) before continuing to insert, update, or delete data in batch mode.

Default: 300 (minimum: 30, maximum10800).

deadlock.retry.delay.ms

Defines the interval to wait (in milliseconds) before retrying the transaction.

Default: 10000 (minimum: 1000, maximum: 300000).

jdbc.trace.level

Defines JDBC logging related to database operations. The following values are valid:

Severe: Indicates a serious failure and is the highest logging level. The JDBC driver uses this level to report errors and exceptions.
Warning: Indicates a potential issue.
Info: Provides informational messages.
Config: Provides configuration messages. The JDBC driver uses this level for global configuration settings.
Fine: Provides basic tracing information. The JDBC driver uses this level for most log messages.
Finer: Provides more detailed tracing information.
Finest: Provides highly detailed tracing information. Finest is the lowest logging level.
Off: Turns off logging.
All: Enables logging of all messages.

max.batch.size

Defines the number of rows that the product processes in each batch during database operations.

Default: 1000 (minimum: 100, maximum:10000).

query.timeout.seconds

Defines the interval (in seconds) to continue the query select attempts.

Default: 300 (minimum: 30, maximum: 3600).

update.timeout.seconds

Defines the interval (in seconds) to continue the insert, update, or delete attempts.

Default: 3600 (minimum: 30, maximum: 10800).