Specifies the maximum time (in minutes) the provider waits for a bulk query response before timing out. Set to 0 to disable the timeout.

Data Type

string

Default Value

"25"

Remarks

When UseBulkAPI is set to true, the driver submits SELECT queries as asynchronous jobs in Certinia. The driver then polls Certinia at regular intervals to check if the results are ready.

This property controls the total amount of time the driver waits for the bulk query to complete before timing out. If the query takes longer than this duration, the connection fails with a timeout error. A longer BulkQueryTimeout allows Certinia more time to process large or complex queries, reducing the chance of failure due to timeouts. However, setting this value too high may cause long waits for queries that are unlikely to complete successfully.

To disable the timeout, set BulkQueryTimeout to 0. A value of 0 or less means the driver has no time limit and waits until Certinia finishes processing the bulk query. Use caution when disabling the timeout: if a query never completes, the driver waits indefinitely and does not return an error.

This property is different from Timeout, which applies to all connection requests and governs inactivity rather than the execution time of a bulk query.

This property is useful when dealing with large datasets or slow-running queries in Certinia Bulk API. Adjusting this value can help balance query success rates and timeout handling based on expected execution time.

This setting applies only when Certinia Bulk API is used.