skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver : Connection Properties
  
Connection Properties
This section lists the JDBC connection properties supported by the SQL Server driver and describes each property. The properties have the form:
property=value
You can use these connection properties with either the JDBC Driver Manager or SQL Server driver data sources unless otherwise noted.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
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 table provides a summary of the connection properties supported by the SQL Server driver and their default values.
Table 63. SQL Server Driver Properties
Property
Default
empty string
None
false
ReadWrite
empty string
auto
2048 (rows)
None
2
empty string
empty string
None
5
1 (second)
1 (data type check is performed if column value is null)
None
None
auto
auto
noDescribe
noDescribe
None
false
false
noEncryption
nonAtomic
connect
false
false
empty string
empty string
empty string
None
2048 (KB of memory)
false
1
false
None
0 (no timeout)
2048 (KB of memory)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
000000000000
-1 (maximum packet size accepted by the database server)
None
1433
empty string
empty string
0 (query does not time out)
0 (no additional processing to determine the correct table name for each column in the result set)
direct
None
false
None
nvarchar
nvarchar
false
implicit
true
None
None
None
false
true
empty string
None
None
This section includes the following topics:
* AccountingInfo
* AlternateServers
* AlwaysReportTriggerResults
* ApplicationIntent
* ApplicationName
* AuthenticationMethod
* BulkLoadBatchSize
* BulkLoadOptions
* CatalogOptions
* ClientHostName
* ClientUser
* CodePageOverride
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* DateTimeInputParameterType
* DateTimeOutputParameterType
* DescribeParameters
* DescribeInputParameters
* DescribeOutputParameters
* Domain
* EnableBulkLoad
* EnableCancelTimeout
* EncryptionMethod
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* FetchTSWTZAsTimestamp
* HostNameInCertificate
* HostProcess
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* JDBCBehavior
* LoadBalancing
* LoadLibraryPath
* LoginTimeout
* LongDataCacheSize
* MaxPooledStatements
* MaxStatements
* NetAddress
* PacketSize
* Password
* PortNumber
* ProgramID
* ProgramName
* QueryTimeout
* ReceiveStringParameterType
* ResultSetMetaDataOptions
* SelectMethod
* SendStringParametersAsUnicode
* ServerName
* SnapshotSerializable
* SpyAttributes
* StringInputParameterType
* StringOutputParameterType
* SuppressConnectionWarnings
* TransactionMode
* TruncateFractionalSeconds
* TrustStore
* TrustStorePassword
* User
* UseServerSideUpdatableCursors
* ValidateServerCertificate
* WSID
* XATransactionGroup
* XMLDescribeType