Citation:
Driver class = class com.mysql.jdbc.Driver v5.1
Prop name = HOST
Prop description = Hostname of MySQL Server
Prop value = null
Prop name = PORT
Prop description = Port number of MySQL Server
Prop value = 3306
Prop name = DBNAME
Prop description = Database name
Prop value = null
Prop name = user
Prop description = Username to authenticate as
Prop value = null
Prop name = password
Prop description = Password to use for authentication
Prop value = null
Prop name = allowLoadLocalInfile
Prop description = Should the driver allow use of 'LOAD DATA LOCAL INFILE...' (defaults to 'true').
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = allowMultiQueries
Prop description = Allow the use of ';' to delimit multiple queries during one statement (true/false), defaults to 'false'
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = allowNanAndInf
Prop description = Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = allowUrlInLocalInfile
Prop description = Should the driver allow URLs in 'LOAD DATA LOCAL INFILE' statements?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = alwaysSendSetIsolation
Prop description = Should the driver always communicate with the database when Connection.setTransactionIsolation() is called? If set to false, the driver will only communicate with the database when the requested transaction isolation is different than the whichever is newer, the last value that was set via Connection.setTransactionIsolation(), or the value that was read from the server when the connection was established. Note that useLocalSessionState=true will force the same behavior as alwaysSendSetIsolation=false, regardless of how alwaysSendSetIsolation is set.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = autoClosePStmtStreams
Prop description = Should the driver automatically call .close() on streams/readers passed as arguments via set*() methods?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = autoDeserialize
Prop description = Should the driver automatically detect and de-serialize objects stored in BLOB fields?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = autoGenerateTestcaseScript
Prop description = Should the driver dump the SQL it is executing, including server-side prepared statements to STDERR?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = autoReconnect
Prop description = Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new transaction. The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly. Alternatively, investigate setting the MySQL server variable "wait_timeout" to some high value rather than the default of 8 hours.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = autoReconnectForPools
Prop description = Use a reconnection strategy appropriate for connection pools (defaults to 'false')
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = blobSendChunkSize
Prop description = Chunk to use when sending BLOB/CLOBs via ServerPreparedStatements
Prop value = 1048576
Prop name = autoSlowLog
Prop description = Instead of using slowQueryThreshold* to determine if a query is slow enough to be logged, maintain statistics that allow the driver to determine queries that are outside the 99th percentile?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = blobsAreStrings
Prop description = Should the driver always treat BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = functionsNeverReturnBlobs
Prop description = Should the driver always treat data from functions returning BLOBs as Strings - specifically to work around dubious metadata returned by the server for GROUP BY clauses?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = cacheCallableStmts
Prop description = Should the driver cache the parsing stage of CallableStatements
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = cachePrepStmts
Prop description = Should the driver cache the parsing stage of PreparedStatements of client-side prepared statements, the "check" for suitability of server-side prepared and server-side prepared statements themselves?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = cacheResultSetMetadata
Prop description = Should the driver cache ResultSetMetaData for Statements and PreparedStatements? (Req. JDK-1.4+, true/false, default 'false')
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = cacheServerConfiguration
Prop description = Should the driver cache the results of 'SHOW VARIABLES' and 'SHOW COLLATION' on a per-URL basis?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = callableStmtCacheSize
Prop description = If 'cacheCallableStmts' is enabled, how many callable statements should be cached?
Prop value = 100
Prop name = capitalizeTypeNames
Prop description = Capitalize type names in DatabaseMetaData? (usually only useful when using WebObjects, true/false, defaults to 'false')
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = characterEncoding
Prop description = If 'useUnicode' is set to true, what character encoding should the driver use when dealing with strings? (defaults is to 'autodetect')
Prop value = null
Prop name = characterSetResults
Prop description = Character set to tell the server to return results as.
Prop value = null
Prop name = clientInfoProvider
Prop description = The name of a class that implements the com.mysql.jdbc.JDBC4ClientInfoProvider interface in order to support JDBC-4.0's Connection.get/setClientInfo() methods
Prop value = com.mysql.jdbc.JDBC4CommentClientInfoProvider
Prop name = clobberStreamingResults
Prop description = This will cause a 'streaming' ResultSet to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = clobCharacterEncoding
Prop description = The character encoding to use for sending and retrieving TEXT, MEDIUMTEXT and LONGTEXT values instead of the configured connection characterEncoding
Prop value = null
Prop name = compensateOnDuplicateKeyUpdateCounts
Prop description = Should the driver compensate for the update counts of "ON DUPLICATE KEY" INSERT statements (2 = 1, 0 = 1) when using prepared statements?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = connectionCollation
Prop description = If set, tells the server to use this collation via 'set collation_connection'
Prop value = null
Prop name = connectionLifecycleInterceptors
Prop description = A comma-delimited list of classes that implement "com.mysql.jdbc.ConnectionLifecycleInterceptor" that should notified of connection lifecycle events (creation, destruction, commit, rollback, setCatalog and setAutoCommit) and potentially alter the execution of these commands. ConnectionLifecycleInterceptors are "stackable", more than one interceptor may be specified via the configuration property as a comma-delimited list, with the interceptors executed in order from left to right.
Prop value = null
Prop name = connectTimeout
Prop description = Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to '0'.
Prop value = 0
Prop name = continueBatchOnError
Prop description = Should the driver continue processing batch commands if one statement fails. The JDBC spec allows either way (defaults to 'true').
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = createDatabaseIfNotExist
Prop description = Creates the database given in the URL if it doesn't yet exist. Assumes the configured user has permissions to create databases.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = defaultFetchSize
Prop description = The driver will call setFetchSize(n) with this value on all newly-created Statements
Prop value = 0
Prop name = useServerPrepStmts
Prop description = Use server-side prepared statements if the server supports them?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = dontTrackOpenResources
Prop description = The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling close() on statements or result sets, this can cause memory leakage. Setting this property to true relaxes this constraint, and can be more memory efficient for some applications.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = dumpQueriesOnException
Prop description = Should the driver dump the contents of the query sent to the server in the message for SQLExceptions?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = dynamicCalendars
Prop description = Should the driver retrieve the default calendar when required, or cache it per connection/session?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = elideSetAutoCommits
Prop description = If using MySQL-4.1 or newer, should the driver only issue 'set autocommit=n' queries when the server's state doesn't match the requested state by Connection.setAutoCommit(boolean)?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = emptyStringsConvertToZero
Prop description = Should the driver allow conversions from empty string fields to numeric values of '0'?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = emulateLocators
Prop description = Should the driver emulate java.sql.Blobs with locators? With this feature enabled, the driver will delay loading the actual Blob data until the one of the retrieval methods (getInputStream(), getBytes(), and so forth) on the blob data stream has been accessed. For this to work, you must use a column alias with the value of the column to the actual name of the Blob. The feature also has the following restrictions: The SELECT that created the result set must reference only one table, the table must have a primary key; the SELECT must alias the original blob column name, specified as a string, to an alternate name; the SELECT must cover all columns that make up the primary key.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = emulateUnsupportedPstmts
Prop description = Should the driver detect prepared statements that are not supported by the server, and replace them with client-side emulated versions?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = enablePacketDebug
Prop description = When enabled, a ring-buffer of 'packetDebugBufferSize' packets will be kept, and dumped when exceptions are thrown in key areas in the driver's code
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = enableQueryTimeouts
Prop description = When enabled, query timeouts set via Statement.setQueryTimeout() use a shared java.util.Timer instance for scheduling. Even if the timeout doesn't expire before the query is processed, there will be memory used by the TimerTask for the given timeout which won't be reclaimed until the time the timeout would have expired if it hadn't been cancelled by the driver. High-load environments might want to consider disabling this functionality.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = explainSlowQueries
Prop description = If 'logSlowQueries' is enabled, should the driver automatically issue an 'EXPLAIN' on the server and send the results to the configured log at a WARN level?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = exceptionInterceptors
Prop description = Comma-delimited list of classes that implement com.mysql.jdbc.ExceptionInterceptor. These classes will be instantiated one per Connection instance, and all SQLExceptions thrown by the driver will be allowed to be intercepted by these interceptors, in a chained fashion, with the first class listed as the head of the chain.
Prop value = null
Prop name = failOverReadOnly
Prop description = When failing over in autoReconnect mode, should the connection be set to 'read-only'?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = gatherPerfMetrics
Prop description = Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = generateSimpleParameterMetadata
Prop description = Should the driver generate simplified parameter metadata for PreparedStatements when no metadata is available either because the server couldn't support preparing the statement, or server-side prepared statements are disabled?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = holdResultsOpenOverStatementClose
Prop description = Should the driver close result sets on Statement.close() as required by the JDBC specification?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = includeInnodbStatusInDeadlockExceptions
Prop description = Include the output of "SHOW ENGINE INNODB STATUS" in exception messages when deadlock exceptions are detected?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = includeThreadDumpInDeadlockExceptions
Prop description = Include a current Java thread dump in exception messages when deadlock exceptions are detected?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = includeThreadNamesAsStatementComment
Prop description = Include the name of the current thread as a comment visible in "SHOW PROCESSLIST", or in Innodb deadlock dumps, useful in correlation with "includeInnodbStatusInDeadlockExceptions=true" and "includeThreadDumpInDeadlockExceptions=true".
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = ignoreNonTxTables
Prop description = Ignore non-transactional table warning for rollback? (defaults to 'false').
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = initialTimeout
Prop description = If autoReconnect is enabled, the initial time to wait between re-connect attempts (in seconds, defaults to '2').
Prop value = 2
Prop name = interactiveClient
Prop description = Set the CLIENT_INTERACTIVE flag, which tells MySQL to timeout connections based on INTERACTIVE_TIMEOUT instead of WAIT_TIMEOUT
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = jdbcCompliantTruncation
Prop description = Should the driver throw java.sql.DataTruncation exceptions when data is truncated as is required by the JDBC specification when connected to a server that supports warnings (MySQL 4.1.0 and newer)? This property has no effect if the server sql-mode includes STRICT_TRANS_TABLES.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = largeRowSizeThreshold
Prop description = What size result set row should the JDBC driver consider "large", and thus use a more memory-efficient way of representing the row internally?
Prop value = 2048
Prop name = loadBalanceStrategy
Prop description = If using a load-balanced connection to connect to SQL nodes in a MySQL Cluster/NDB configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should the driver use: (1) "random" - the driver will pick a random host for each request. This tends to work better than round-robin, as the randomness will somewhat account for spreading loads where requests vary in response time, while round-robin can sometimes lead to overloaded nodes if there are variations in response times across the workload. (2) "bestResponseTime" - the driver will route the request to the host that had the best response time for the previous transaction.
Prop value = random
Prop name = loadBalanceBlacklistTimeout
Prop description = Time in milliseconds between checks of servers which are unavailable.
Prop value = 0
Prop name = loadBalancePingTimeout
Prop description = Time in milliseconds to wait for ping response from each of load-balanced physical connections when using load-balanced Connection.
Prop value = 0
Prop name = loadBalanceValidateConnectionOnSwapServer
Prop description = Should the load-balanced Connection explicitly check whether the connection is live when swapping to a new physical connection at commit/rollback?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = loadBalanceConnectionGroup
Prop description = Logical group of load-balanced connections within a classloader, used to manage different groups independently. If not specified, live management of load-balanced connections is disabled.
Prop value = null
Prop name = loadBalanceExceptionChecker
Prop description = Fully-qualified class name of custom exception checker. The class must implement com.mysql.jdbc.LoadBalanceExceptionChecker interface, and is used to inspect SQLExceptions and determine whether they should trigger fail-over to another host in a load-balanced deployment.
Prop value = com.mysql.jdbc.StandardLoadBalanceExceptionChecker
Prop name = loadBalanceSQLStateFailover
Prop description = Comma-delimited list of SQLState codes used by default load-balanced exception checker to determine whether a given SQLException should trigger failover. The SQLState of a given SQLException is evaluated to determine whether it begins with any value in the comma-delimited list.
Prop value = null
Prop name = loadBalanceSQLExceptionSubclassFailover
Prop description = Comma-delimited list of classes/interfaces used by default load-balanced exception checker to determine whether a given SQLException should trigger failover. The comparison is done using Class.isInstance(SQLException) using the thrown SQLException.
Prop value = null
Prop name = loadBalanceEnableJMX
Prop description = Enables JMX-based management of load-balanced connection groups, including live addition/removal of hosts from load-balancing pool.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = loadBalanceAutoCommitStatementRegex
Prop description = When load-balancing is enabled for auto-commit statements (via loadBalanceAutoCommitStatementThreshold), the statement counter will only increment when the SQL matches the regular expression. By default, every statement issued matches.
Prop value = null
Prop name = loadBalanceAutoCommitStatementThreshold
Prop description = When auto-commit is enabled, the number of statements which should be executed before triggering load-balancing to rebalance. Default value of 0 causes load-balanced connections to only rebalance when exceptions are encountered, or auto-commit is disabled and transactions are explicitly committed or rolled back.
Prop value = 0
Prop name = localSocketAddress
Prop description = Hostname or IP address given to explicitly configure the interface that the driver will bind the client side of the TCP/IP connection to when connecting.
Prop value = null
Prop name = locatorFetchBufferSize
Prop description = If 'emulateLocators' is configured to 'true', what size buffer should be used when fetching BLOB data for getBinaryInputStream?
Prop value = 1048576
Prop name = logger
Prop description = The name of a class that implements "com.mysql.jdbc.log.Log" that will be used to log messages to. (default is "com.mysql.jdbc.log.StandardLogger", which logs to STDERR)
Prop value = com.mysql.jdbc.log.StandardLogger
Prop name = logSlowQueries
Prop description = Should queries that take longer than 'slowQueryThresholdMillis' be logged?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = logXaCommands
Prop description = Should the driver log XA commands sent by MysqlXaConnection to the server, at the DEBUG level of logging?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = maintainTimeStats
Prop description = Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to false removes at least two calls to System.getCurrentTimeMillis() per query.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = maxQuerySizeToLog
Prop description = Controls the maximum length/size of a query that will get logged when profiling or tracing
Prop value = 2048
Prop name = maxReconnects
Prop description = Maximum number of reconnects to attempt if autoReconnect is true, default is '3'.
Prop value = 3
Prop name = retriesAllDown
Prop description = When using loadbalancing, the number of times the driver should cycle through available hosts, attempting to connect. Between cycles, the driver will pause for 250ms if no servers are available.
Prop value = 120
Prop name = maxRows
Prop description = The maximum number of rows to return (0, the default means return all rows).
Prop value = -1
Prop name = metadataCacheSize
Prop description = The number of queries to cache ResultSetMetadata for if cacheResultSetMetaData is set to 'true' (default 50)
Prop value = 50
Prop name = netTimeoutForStreamingResults
Prop description = What value should the driver automatically set the server setting 'net_write_timeout' to when the streaming result sets feature is in use? (value has unit of seconds, the value '0' means the driver will not try and adjust this value)
Prop value = 600
Prop name = noAccessToProcedureBodies
Prop description = When determining procedure parameter types for CallableStatements, and the connected user can't access procedure bodies through "SHOW CREATE PROCEDURE" or select on mysql.proc should the driver instead create basic metadata (all parameters reported as IN VARCHARs, but allowing registerOutParameter() to be called on them anyway) instead of throwing an exception?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = noDatetimeStringSync
Prop description = Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = noTimezoneConversionForTimeType
Prop description = Don't convert TIME values using the server timezone if 'useTimezone'='true'
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = nullCatalogMeansCurrent
Prop description = When DatabaseMetadataMethods ask for a 'catalog' parameter, does the value null mean use the current catalog? (this is not JDBC-compliant, but follows legacy behavior from earlier versions of the driver)
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = nullNamePatternMatchesAll
Prop description = Should DatabaseMetaData methods that accept *pattern parameters treat null the same as '%' (this is not JDBC-compliant, however older versions of the driver accepted this departure from the specification)
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = packetDebugBufferSize
Prop description = The maximum number of packets to retain when 'enablePacketDebug' is true
Prop value = 20
Prop name = padCharsWithSpace
Prop description = If a result set column has the CHAR type and the value does not fill the amount of characters specified in the DDL for the column, should the driver pad the remaining characters with space (for ANSI compliance)?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = paranoid
Prop description = Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? (defaults to 'false')
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = pedantic
Prop description = Follow the JDBC spec to the letter.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = pinGlobalTxToPhysicalConnection
Prop description = When using XAConnections, should the driver ensure that operations on a given XID are always routed to the same physical connection? This allows the XAConnection to support "XA START ... JOIN" after "XA END" has been called
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = populateInsertRowWithDefaultValues
Prop description = When using ResultSets that are CONCUR_UPDATABLE, should the driver pre-populate the "insert" row with default values from the DDL for the table used in the query so those values are immediately available for ResultSet accessors? This functionality requires a call to the database for metadata each time a result set of this type is created. If disabled (the default), the default values will be populated by the an internal call to refreshRow() which pulls back default values and/or values changed by triggers.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = prepStmtCacheSize
Prop description = If prepared statement caching is enabled, how many prepared statements should be cached?
Prop value = 25
Prop name = prepStmtCacheSqlLimit
Prop description = If prepared statement caching is enabled, what's the largest SQL the driver will cache the parsing for?
Prop value = 256
Prop name = processEscapeCodesForPrepStmts
Prop description = Should the driver process escape codes in queries that are prepared?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = profilerEventHandler
Prop description = Name of a class that implements the interface com.mysql.jdbc.profiler.ProfilerEventHandler that will be used to handle profiling/tracing events.
Prop value = com.mysql.jdbc.profiler.LoggingProfilerEventHandler
Prop name = profileSql
Prop description = Deprecated, use 'profileSQL' instead. Trace queries and their execution/fetch times on STDERR (true/false) defaults to 'false'
Prop value = null
Prop name = profileSQL
Prop description = Trace queries and their execution/fetch times to the configured logger (true/false) defaults to 'false'
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = propertiesTransform
Prop description = An implementation of com.mysql.jdbc.ConnectionPropertiesTransform that the driver will use to modify URL properties passed to the driver before attempting a connection
Prop value = null
Prop name = queriesBeforeRetryMaster
Prop description = Number of queries to issue before falling back to master when failed over (when using multi-host failover). Whichever condition is met first, 'queriesBeforeRetryMaster' or 'secondsBeforeRetryMaster' will cause an attempt to be made to reconnect to the master. Defaults to 50.
Prop value = 50
Prop name = queryTimeoutKillsConnection
Prop description = If the timeout given in Statement.setQueryTimeout() expires, should the driver forcibly abort the Connection instead of attempting to abort the query?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = reconnectAtTxEnd
Prop description = If autoReconnect is set to true, should the driver attempt reconnections at the end of every transaction?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = relaxAutoCommit
Prop description = If the version of MySQL the driver connects to does not support transactions, still allow calls to commit(), rollback() and setAutoCommit() (true/false, defaults to 'false')?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = reportMetricsIntervalMillis
Prop description = If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?
Prop value = 30000
Prop name = requireSSL
Prop description = Require SSL connection if useSSL=true? (defaults to 'false').
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = resourceId
Prop description = A globally unique name that identifies the resource that this datasource or connection is connected to, used for XAResource.isSameRM() when the driver can't determine this value based on hostnames used in the URL
Prop value = null
Prop name = resultSetSizeThreshold
Prop description = If the usage advisor is enabled, how many rows should a result set contain before the driver warns that it is suspiciously large?
Prop value = 100
Prop name = retainStatementAfterResultSetClose
Prop description = Should the driver retain the Statement reference in a ResultSet after ResultSet.close() has been called. This is not JDBC-compliant after JDBC-4.0.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = rewriteBatchedStatements
Prop description = Should the driver use multiqueries (irregardless of the setting of "allowMultiQueries") as well as rewriting of prepared statements for INSERT into multi-value inserts when executeBatch() is called? Notice that this has the potential for SQL injection if using plain java.sql.Statements and your code doesn't sanitize input correctly. Notice that for prepared statements, server-side prepared statements can not currently take advantage of this rewrite option, and that if you don't specify stream lengths when using PreparedStatement.set*Stream(), the driver won't be able to determine the optimum number of parameters per batch and you might receive an error from the driver that the resultant packet is too large. Statement.getGeneratedKeys() for these rewritten statements only works when the entire batch includes INSERT statements.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = rollbackOnPooledClose
Prop description = Should the driver issue a rollback() when the logical connection in a pool is closed?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = roundRobinLoadBalance
Prop description = When autoReconnect is enabled, and failoverReadonly is false, should we pick hosts to connect to on a round-robin basis?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = runningCTS13
Prop description = Enables workarounds for bugs in Sun's JDBC compliance testsuite version 1.3
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = secondsBeforeRetryMaster
Prop description = How long should the driver wait, when failed over, before attempting
Prop value = 30
Prop name = selfDestructOnPingSecondsLifetime
Prop description = If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connnection's lifetime exceeds this value.
Prop value = 0
Prop name = selfDestructOnPingMaxOperations
Prop description = =If set to a non-zero value, the driver will report close the connection and report failure when Connection.ping() or Connection.isValid(int) is called if the connnection's count of commands sent to the server exceeds this value.
Prop value = 0
Prop name = serverTimezone
Prop description = Override detection/mapping of timezone. Used when timezone from server doesn't map to Java timezone
Prop value = null
Prop name = sessionVariables
Prop description = A comma-separated list of name/value pairs to be sent as SET SESSION ... to the server when the driver connects.
Prop value = null
Prop name = slowQueryThresholdMillis
Prop description = If 'logSlowQueries' is enabled, how long should a query (in ms) before it is logged as 'slow'?
Prop value = 2000
Prop name = slowQueryThresholdNanos
Prop description = If 'useNanosForElapsedTime' is set to true, and this property is set to a non-zero value, the driver will use this threshold (in nanosecond units) to determine if a query was slow.
Prop value = 0
Prop name = socketFactory
Prop description = The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.
Prop value = com.mysql.jdbc.StandardSocketFactory
Prop name = socketTimeout
Prop description = Timeout on network socket operations (0, the default means no timeout).
Prop value = 0
Prop name = statementInterceptors
Prop description = A comma-delimited list of classes that implement "com.mysql.jdbc.StatementInterceptor" that should be placed "in between" query execution to influence the results. StatementInterceptors are "chainable", the results returned by the "current" interceptor will be passed on to the next in in the chain, from left-to-right order, as specified in this property.
Prop value = null
Prop name = strictFloatingPoint
Prop description = Used only in older versions of compliance test
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = strictUpdates
Prop description = Should the driver do strict checking (all primary keys selected) of updatable result sets (true, false, defaults to 'true')?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = overrideSupportsIntegrityEnhancementFacility
Prop description = Should the driver return "true" for DatabaseMetaData.supportsIntegrityEnhancementFacility() even if the database doesn't support it to workaround applications that require this method to return "true" to signal support of foreign keys, even though the SQL specification states that this facility contains much more than just foreign key support (one such application being OpenOffice)?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = tcpNoDelay
Prop description = If connecting using TCP/IP, should the driver set SO_TCP_NODELAY (disabling the Nagle Algorithm)?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = tcpKeepAlive
Prop description = If connecting using TCP/IP, should the driver set SO_KEEPALIVE?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = tcpRcvBuf
Prop description = If connecting using TCP/IP, should the driver set SO_RCV_BUF to the given value? The default value of '0', means use the platform default value for this property)
Prop value = 0
Prop name = tcpSndBuf
Prop description = If connecting using TCP/IP, should the driver set SO_SND_BUF to the given value? The default value of '0', means use the platform default value for this property)
Prop value = 0
Prop name = tcpTrafficClass
Prop description = If connecting using TCP/IP, should the driver set traffic class or type-of-service fields ?See the documentation for java.net.Socket.setTrafficClass() for more information.
Prop value = 0
Prop name = tinyInt1isBit
Prop description = Should the driver treat the datatype TINYINT(1) as the BIT type (because the server silently converts BIT -> TINYINT(1) when creating tables)?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = traceProtocol
Prop description = Should trace-level network protocol be logged?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = treatUtilDateAsTimestamp
Prop description = Should the driver treat java.util.Date as a TIMESTAMP for the purposes of PreparedStatement.setObject()?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = transformedBitIsBoolean
Prop description = If the driver converts TINYINT(1) to a different type, should it use BOOLEAN instead of BIT for future compatibility with MySQL-5.0, as MySQL-5.0 has a BIT type?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useBlobToStoreUTF8OutsideBMP
Prop description = Tells the driver to treat [MEDIUM/LONG]BLOB columns as [LONG]VARCHAR columns holding text encoded in UTF-8 that has characters outside the BMP (4-byte encodings), which MySQL server can't handle natively.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = utf8OutsideBmpExcludedColumnNamePattern
Prop description = When "useBlobToStoreUTF8OutsideBMP" is set to "true", column names matching the given regex will still be treated as BLOBs unless they match the regex specified for "utf8OutsideBmpIncludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
Prop value = null
Prop name = utf8OutsideBmpIncludedColumnNamePattern
Prop description = Used to specify exclusion rules to "utf8OutsideBmpExcludedColumnNamePattern". The regex must follow the patterns used for the java.util.regex package.
Prop value = null
Prop name = useCompression
Prop description = Use zlib compression when communicating with the server (true/false)? Defaults to 'false'.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useColumnNamesInFindColumn
Prop description = Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a "column name" to ResultSet methods like findColumn(), or getters that took a String property. JDBC-4.0 clarified "column name" to mean the label, as given in an "AS" clause and returned by ResultSetMetaData.getColumnLabel(), and if no AS clause, the column name. Setting this property to "true" will give behavior that is congruent to JDBC-3.0 and earlier versions of the JDBC specification, but which because of the specification bug could give unexpected results. This property is preferred over "useOldAliasMetadataBehavior" unless you need the specific behavior that it provides with respect to ResultSetMetadata.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useConfigs
Prop description = Load the comma-delimited list of configuration properties before parsing the URL or applying user-specified properties. These configurations are explained in the 'Configurations' of the documentation.
Prop value = null
Prop name = useCursorFetch
Prop description = If connected to MySQL > 5.0.2, and setFetchSize() > 0 on a statement, should that statement use cursor-based fetching to retrieve rows?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useDynamicCharsetInfo
Prop description = Should the driver use a per-connection cache of character set information queried from the server when necessary, or use a built-in static mapping that is more efficient, but isn't aware of custom character sets or character sets implemented after the release of the JDBC driver?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useDirectRowUnpack
Prop description = Use newer result set row unpacking code that skips a copy from network buffers to a MySQL packet instance and instead reads directly into the result set row data buffers.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useFastIntParsing
Prop description = Use internal String->Integer conversion routines to avoid excessive object creation?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useFastDateParsing
Prop description = Use internal String->Date/Time/Timestamp conversion routines to avoid excessive object creation?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useHostsInPrivileges
Prop description = Add '@hostname' to users in DatabaseMetaData.getColumn/TablePrivileges() (true/false), defaults to 'true'.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useInformationSchema
Prop description = When connected to MySQL-5.0.7 or newer, should the driver use the INFORMATION_SCHEMA to derive information used by DatabaseMetaData?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useJDBCCompliantTimezoneShift
Prop description = Should the driver use JDBC-compliant rules when converting TIME/TIMESTAMP/DATETIME values' timezone information for those JDBC arguments which take a java.util.Calendar argument? (Notice that this option is exclusive of the "useTimezone=true" configuration option.)
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useLocalSessionState
Prop description = Should the driver refer to the internal values of autocommit and transaction isolation that are set by Connection.setAutoCommit() and Connection.setTransactionIsolation() and transaction state as maintained by the protocol, rather than querying the database or blindly sending commands to the database for commit() or rollback() method calls?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useLocalTransactionState
Prop description = Should the driver use the in-transaction state provided by the MySQL protocol to determine if a commit() or rollback() should actually be sent to the database?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useLegacyDatetimeCode
Prop description = Use code for DATE/TIME/DATETIME/TIMESTAMP handling in result sets and statements that consistently handles timezone conversions from client to server and back again, or use the legacy code for these datatypes that has been in the driver for backwards-compatibility?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useNanosForElapsedTime
Prop description = For profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (JDK >= 1.5)?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useOldAliasMetadataBehavior
Prop description = Should the driver use the legacy behavior for "AS" clauses on columns and tables, and only return aliases (if any) for ResultSetMetaData.getColumnName() or ResultSetMetaData.getTableName() rather than the original column/table name? In 5.0.x, the default value was true.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useOldUTF8Behavior
Prop description = Use the UTF-8 behavior the driver did when communicating with 4.0 and older servers
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useOnlyServerErrorMessages
Prop description = Don't prepend 'standard' SQLState error messages to error messages returned by the server.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useReadAheadInput
Prop description = Use newer, optimized non-blocking, buffered input stream when reading from the server?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useSqlStateCodes
Prop description = Use SQL Standard state codes instead of 'legacy' X/Open/SQL state codes (true/false), default is 'true'
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useSSL
Prop description = Use SSL when communicating with the server (true/false), defaults to 'false'
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useSSPSCompatibleTimezoneShift
Prop description = If migrating from an environment that was using server-side prepared statements, and the configuration property "useJDBCCompliantTimeZoneShift" set to "true", use compatible behavior when not using server-side prepared statements when sending TIMESTAMP values to the MySQL server.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useStreamLengthsInPrepStmts
Prop description = Honor stream length parameter in PreparedStatement/ResultSet.setXXXStream() method calls (true/false, defaults to 'true')?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useTimezone
Prop description = Convert time/date types between client and server timezones (true/false, defaults to 'false')?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = ultraDevHack
Prop description = Create PreparedStatements for prepareCall() when required, because UltraDev is broken and issues a prepareCall() for _all_ statements? (true/false, defaults to 'false')
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useUnbufferedInput
Prop description = Don't use BufferedInputStream for reading data from the server
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useUnicode
Prop description = Should the driver use Unicode character encodings when handling strings? Should only be used when the driver can't determine the character set mapping, or you are trying to 'force' the driver to use a character set that MySQL either doesn't natively support (such as UTF-8), true/false, defaults to 'true'
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useUsageAdvisor
Prop description = Should the driver issue 'usage' warnings advising proper and efficient usage of JDBC and MySQL Connector/J to the log (true/false, defaults to 'false')?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = yearIsDateType
Prop description = Should the JDBC driver treat the MySQL type "YEAR" as a java.sql.Date, or as a SHORT?
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = zeroDateTimeBehavior
Prop description = What should happen when the driver encounters DATETIME values that are composed entirely of zeros (used by MySQL to represent invalid dates)? Valid values are "exception", "round" and "convertToNull".
Prop value = exception
prop choice 0 = exception
prop choice 1 = round
prop choice 2 = convertToNull
Prop name = useJvmCharsetConverters
Prop description = Always use the character encoding routines built into the JVM, rather than using lookup tables for single-byte character sets?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useGmtMillisForDatetimes
Prop description = Convert between session timezone and GMT before creating Date and Timestamp instances (value of "false" is legacy behavior, "true" leads to more JDBC-compliant behavior.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = dumpMetadataOnColumnNotFound
Prop description = Should the driver dump the field-level metadata of a result set into the exception message when ResultSet.findColumn() fails?
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = clientCertificateKeyStoreUrl
Prop description = URL to the client certificate KeyStore (if not specified, use defaults)
Prop value = null
Prop name = trustCertificateKeyStoreUrl
Prop description = URL to the trusted root certificate KeyStore (if not specified, use defaults)
Prop value = null
Prop name = clientCertificateKeyStoreType
Prop description = KeyStore type for client certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
Prop value = JKS
Prop name = clientCertificateKeyStorePassword
Prop description = Password for the client certificates KeyStore
Prop value = null
Prop name = trustCertificateKeyStoreType
Prop description = KeyStore type for trusted root certificates (NULL or empty means use the default, which is "JKS". Standard keystore types supported by the JVM are "JKS" and "PKCS12", your environment may have more available depending on what security products are installed and available to the JVM.
Prop value = JKS
Prop name = trustCertificateKeyStorePassword
Prop description = Password for the trusted root certificates KeyStore
Prop value = null
Prop name = verifyServerCertificate
Prop description = If "useSSL" is set to "true", should the driver verify the server's certificate? When using this feature, the keystore parameters should be specified by the "clientCertificateKeyStore*" properties, rather than system properties.
Prop value = true
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = useAffectedRows
Prop description = Don't set the CLIENT_FOUND_ROWS flag when connecting to the server (not JDBC-compliant, will break most applications that rely on "found" rows vs. "affected rows" for DML statements), but does cause "correct" update counts from "INSERT ... ON DUPLICATE KEY UPDATE" statements to be returned by the server.
Prop value = false
prop choice 0 = true
prop choice 1 = false
prop choice 2 = yes
prop choice 3 = no
Prop name = passwordCharacterEncoding
Prop description = What character encoding is used for passwords? Leaving this set to the default value (null), uses the platform character set, which works for ISO8859_1 (i.e. "latin1") passwords. For passwords in other character encodings, the encoding will have to be specified with this property, as it's not possible for the driver to auto-detect this.
Prop value = null
Prop name = maxAllowedPacket
Prop description = Maximum allowed packet size to send to server. If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. This value will not take effect if set larger than the value of 'max_allowed_packet'.
Prop value = -1
