skip to main content
DataDirect Connect Drivers : MySQL Driver : Connection Properties
  
Connection Properties
This section lists the JDBC connection properties supported by the MySQL 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 the 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 MySQL driver and their default values.
Table 38. MySQL Driver Properties
Property
Default
empty string
None
empty string
1000 (rows)
2
empty string
empty string
None
5
1 (second)
1 (data type check is performed if column value is null)
None
None
noEncryption
nonAtomic
connect
false
empty string
empty string
None
false
2048 (KB of memory)
false
false
1
None
None
None
false
1048576 (bytes)
0 (no timeout)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
None
3306
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)
None
None
false
None
None
None
true
This section includes the following topics:
* AccountingInfo
* AlternateServers
* ApplicationName
* BulkLoadBatchSize
* CatalogOptions
* ClientHostName
* ClientUser
* CodePageOverride
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* EncryptionMethod
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* HostNameInCertificate
* ImportStatementPool
* InitializationString
* InOrderColumnAccess
* InsensitiveResultSetBufferSize
* InteractiveClient
* JavaDoubleToString
* JDBCBehavior
* KeyPassword
* KeyStore
* KeyStorePassword
* LoadBalancing
* LobCommandSize
* LoginTimeout
* MaxPooledStatements
* MaxStatements
* Password
* PortNumber
* ProgramID
* QueryTimeout
* ResultSetMetaDataOptions
* ServerName
* SpyAttributes
* TreatBinaryAsChar
* TrustStore
* TrustStorePassword
* User
* ValidateServerCertificate