Connection property descriptions

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 7. 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 8. 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 9. 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 10. 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 11. 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 12. 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 13. 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 14. 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