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 1. Sybase Driver Properties
Property Default
AccountingInfo empty string
AlternateServers None
ApplicationName empty string
AuthenticationMethod userIdPassword
BatchPerformanceWorkaround false
BulkLoadBatchSize 2048 (rows)
CatalogOptions 2
ClientHostName empty string
ClientUser empty string
CodePageOverride None
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion

TLSv1
Database None
DatabaseName None
EnableBulkLoad false
EnableCancelTimeout false
EncryptionMethod noEncryption
ErrorBehavior exception
FailoverGranularity nonAtomic
FailoverMode connect
FailoverPreconnect false
FetchTWFSasTime true
HostNameInCertificate empty string
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString false
JDBCBehavior 1
LoadBalancing false
LoginTimeout 0 (no timeout)
LongDataCacheSize 2048 (KB of memory)
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
PacketSize -1 (maximum packet size accepted by the database server)
Password None
PortNumber Varies depending on operating system
PrepareMethod StoredProcIfParam
ProgramID 0000016a
QueryTimeout 0 (query does not time out)
RegisterStatementPoolMonitorMBean false
ResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
SelectMethod direct
ServerName None
ServicePrincipalName None
SpyAttributes None
TransactionMode implicit
TrustStore None
TrustStorePassword None
UseAlternateProductInfo false
User None
ValidateServerCertificate true