skip to main content
DataDirect Connect Drivers : Sybase Driver : Connection Properties
  
Connection Properties
This section lists the JDBC connection properties supported by the Sybase 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 DataDirect Connect Series for JDBC 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 Sybase driver and their default values.
Table 71. Sybase Driver Properties
Property
Default
empty string
None
empty string
userIdPassword
false
2048 (rows)
2
empty string
empty string
None
5
1 (second)
1 (data type check is performed if column value is null)
None
None
false
false
noEncryption
exception
nonAtomic
connect
false
true
empty string
empty string
None
2048 (KB of memory)
false
1
false
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)
-1 (maximum packet size accepted by the database server)
None
Varies depending on operating system
StoredProcIfParam
0000016a
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
None
None
implicit
None
None
false
None
true
This section includes the following topics:
* AccountingInfo
* AlternateServers
* ApplicationName
* AuthenticationMethod
* BatchPerformanceWorkaround
* BulkLoadBatchSize
* CatalogOptions
* ClientHostName
* ClientUser
* CodePageOverride
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* EnableBulkLoad
* EnableCancelTimeout
* EncryptionMethod
* ErrorBehavior
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* FetchTWFSasTime
* HostNameInCertificate
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* JDBCBehavior
* LoadBalancing
* LoginTimeout
* LongDataCacheSize
* MaxPooledStatements
* MaxStatements
* PacketSize
* Password
* PortNumber
* PrepareMethod
* ProgramID
* QueryTimeout
* ResultSetMetaDataOptions
* SelectMethod
* ServerName
* ServicePrincipalName
* SpyAttributes
* TransactionMode
* TrustStore
* TrustStorePassword
* UseAlternateProductInfo
* User
* ValidateServerCertificate