DatabaseLink`
DatabaseLink`

$SQLTimeout

$SQLTimeout

gives the default time in seconds that DatabaseLink waits while opening connections and executing database queries.

Details and Options

  • To use $SQLTimeout, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The default setting is Automatic, which falls back on a driver-dependent default.

Examples

open allclose all

Basic Examples  (1)

Set a timeout value for a query:

Scope  (1)

Setting $SQLTimeout affects the default timeout for all DatabaseLink functions with a "Timeout" option:

Possible Issues  (1)

Not all JDBC drivers implement timeout-related methods. Setting $SQLTimeout (or the "Timeout" option) will have no effect with certain drivers: