You can use connection properties to customize the driver for your environment. This section lists the connection properties supported by the driver and describes each property. You can use these connection properties with either the JDBC DriverManager or a JDBC DataSource. For a DriverManager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value). Connection property names are case-insensitive. For example, Password is the same as password.

Note: In a JDBC DataSource, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.

The following tables provide a summary of supported connection properties by functionality, including their corresponding data source methods, and their default values.

Required properties

The following table summarizes connection properties which are required to connect to a Jira data source.

Table 1. Required Properties
Property Data Source Method Default
ServerName setServerName None
Password setPassword None
User setUser None

Data encryption properties

The following table summarizes connection properties which can be used to enable SSL.

Table 2. Data Encryption Properties
Property Data Source Method Default
CryptoProtocolVersion setCryptoProtocolVersion None
KeyPassword setKeyPassword None
KeyStore setKeyStore None
KeyStorePassword setKeyStorePassword None
HostNameInCertificate setHostNameInCertificate None
TrustStore setTrustStore None
TrustStorePassword setTrustStorePassword None
ValidateServerCertificate setValidateServerCertificate true

Proxy server properties

The following table summarizes proxy server connection properties.

Table 3. Proxy Server Properties
Property Data Source Method Default
ProxyHost setProxyHost Empty string
ProxyPassword setProxyPassword Empty string
ProxyPort setProxyPort 0
ProxyUser setProxyUser Empty string

Web service properties

The following table summarizes Web service connection properties, including those related to timeouts.

Table 4. Web Service Properties
Property Data Source Method Default
LoginTimeout setLoginTimeout 0 (no timeout)
StmtCallLimit setStmtCallLimit 0 (no limit)
StmtCallLimitBehavior setStmtCallLimitBehavior errorAlways
WSFetchSize setWSFetchSize 0 (maximum of 1000 rows)
WSPoolSize setWSPoolSize 1
WSRetryCount setWSRetryCount 5
WSTimeout setWSTimeout 120 (seconds)

Data type properties

The following table summarizes connection properties which can be used to handle data types.

Table 5. Data Type Properties
Property Data Source Method Default
ConvertNull setConvertNull 1 (data type check is performed if column value is null)
JDBCBehavior setJDBCBehavior 1 (data types described using JDBC 3.0-equivalent data types)

Timeout properties

The following table summarizes timeout connection properties.

Table 6. Timeout Properties
Property Data Source Method Default
LoginTimeout setLoginTimeout 0 (no timeout)
WSRetryCount setWSRetryCount 0 (no retries for timed-out requests)
WSTimeout setWSTimeout 120 (seconds)

Statement pooling properties

The following table summarizes statement pooling connection properties.

Table 7. Statement Pooling Properties
Property Data Source Method Default
ImportStatementPool setImportStatementPool Empty string
MaxPooledStatements setMaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean false

Additional properties

The following table summarizes additional connection properties.

Table 8. Additional Properties
Property Data Source Method Default
DebugRecord setDebugRecord None
FetchSize setFetchSize 100 (rows)
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048 (KB of memory)
LogConfigFile setLogConfigFile ddlogging.properties
PortNumber setPortNumber

For http connections:

80

For https connections:

443
ReadAhead setReadAhead 0
SpyAttributes setSpyAttributes None