MssqlConnection
host
(string, required)
host
(string, required)The hostname or ip address of the MSSQL server
Example: "example.org"
port
(integer)
port
(integer)The port of the MSSQL server
Default: 1433
Example: 1433
username
(string, required)
username
(string, required)The username to connect to the MSSQL server
password
(string, required)
password
(string, required)The password to connect to the MSSQL server
domain
(string)
domain
(string)The domain to use
database
(string, required)
database
(string, required)The database to use
protocol
(string, enum)
protocol
(string, enum)The protocol version to use for the connection to the MSSQL server
This element must be one of the following enum values:
7_1
7_2
7_3_A
7_3_B
7_4
Default: "7_4"
useEncryption
(boolean)
useEncryption
(boolean)Use encryption for the connection to the MSSQL server
Default: true
assumeUTC
(boolean)
assumeUTC
(boolean)Assume UTC values for the connection
Default: true
connectTimeout
(integer)
connectTimeout
(integer)The number of milliseconds before the attempt to connect is considered failed
Default: 15000
requestTimeout
(integer)
requestTimeout
(integer)The number of milliseconds before a request is considered failed, or 0 for no timeout
Default: 15000
cancelTimeout
(integer)
cancelTimeout
(integer)The number of milliseconds before the cancel (abort) of a request is considered failed
Default: 5000
maxPoolSize
(integer)
maxPoolSize
(integer)The maximum number of connection mantained in the connection pool
Default: 5
connectionStrategy
(object)
connectionStrategy
(object)If a connection attempt fails, retries will be performed with increasing delay (waiting time) in between. The following parameters control how these delays behave.
Properties of the connectionStrategy
object:
initialDelay
(integer)
initialDelay
(integer)Delay (waiting time) of the first connection retry (in milliseconds). For subsequent retries, the delay will be increased according to the parameter incrementFactor which has a default value of 2.
Default: 1000
Additional restrictions:
Minimum:
1000
maxDelay
(integer)
maxDelay
(integer)Maximum delay (waiting time) to wait until the next retry (in milliseconds). The delay (waiting time) for any subsequent connection retry will not be larger than this value. Must be strictly greater than initialDelay.
Default: 30000
incrementFactor
(integer)
incrementFactor
(integer)The factor used to increment initialDelay up to maxDelay. For example if initialDelay is set to 1000 and maxDelay to 5000 the values for the delay would be 1000, 2000, 4000, 5000.
Default: 2
Additional restrictions:
Minimum:
2
Last updated