false,			"Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?",			"3.1.2", DEBUGING_PROFILING_CATEGORY, 1);	private BooleanConnectionProperty generateSimpleParameterMetadata = new BooleanConnectionProperty(			"generateSimpleParameterMetadata", false, "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?"			, "5.0.5", MISC_CATEGORY, Integer.MIN_VALUE);	private boolean highAvailabilityAsBoolean = false;	private BooleanConnectionProperty holdResultsOpenOverStatementClose = new BooleanConnectionProperty(			"holdResultsOpenOverStatementClose",			false,			"Should the driver close result sets on Statement.close() as required by the JDBC specification?",			"3.1.7", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty includeInnodbStatusInDeadlockExceptions = new BooleanConnectionProperty(			"includeInnodbStatusInDeadlockExceptions",			false,			"Include the output of \"SHOW ENGINE INNODB STATUS\" in exception messages when deadlock exceptions are detected?",			"5.0.7", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty ignoreNonTxTables = new BooleanConnectionProperty(			"ignoreNonTxTables",			false,			"Ignore non-transactional table warning for rollback? (defaults to 'false').",			"3.0.9", MISC_CATEGORY, Integer.MIN_VALUE);	private IntegerConnectionProperty initialTimeout = new IntegerConnectionProperty(			"initialTimeout", 2, 1, Integer.MAX_VALUE,			"If autoReconnect is enabled, the"					+ " initial time to wait between"					+ " re-connect attempts (in seconds, defaults to '2').",			"1.1", HA_CATEGORY, 5);	private BooleanConnectionProperty isInteractiveClient = new BooleanConnectionProperty(			"interactiveClient",			false,			"Set the CLIENT_INTERACTIVE flag, which tells MySQL "					+ "to timeout connections based on INTERACTIVE_TIMEOUT instead of WAIT_TIMEOUT",			"3.1.0", CONNECTION_AND_AUTH_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty jdbcCompliantTruncation = new BooleanConnectionProperty(			"jdbcCompliantTruncation",			true,			"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)?", "3.1.2", MISC_CATEGORY,			Integer.MIN_VALUE);	private boolean jdbcCompliantTruncationForReads =		this.jdbcCompliantTruncation.getValueAsBoolean();	private StringConnectionProperty loadBalanceStrategy = new StringConnectionProperty(			"loadBalanceStrategy",			"random",			new String[] {"random", "bestResponseTime"},			"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 balancin 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.",			"5.0.6", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);	private StringConnectionProperty localSocketAddress = new StringConnectionProperty("localSocketAddress",			null, "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.",			"5.0.5", CONNECTION_AND_AUTH_CATEGORY, Integer.MIN_VALUE);	private MemorySizeConnectionProperty locatorFetchBufferSize = new MemorySizeConnectionProperty(			"locatorFetchBufferSize",			1024 * 1024,			0,			Integer.MAX_VALUE,			"If 'emulateLocators' is configured to 'true', what size "					+ " buffer should be used when fetching BLOB data for getBinaryInputStream?",			"3.2.1", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);	private StringConnectionProperty loggerClassName = new StringConnectionProperty(			"logger", STANDARD_LOGGER_NAME,			"The name of a class that implements '" + Log.class.getName()					+ "' that will be used to log messages to."					+ "(default is '" + STANDARD_LOGGER_NAME + "', which "					+ "logs to STDERR)", "3.1.1", DEBUGING_PROFILING_CATEGORY,			0);	private BooleanConnectionProperty logSlowQueries = new BooleanConnectionProperty(			"logSlowQueries",			false,			"Should queries that take longer than 'slowQueryThresholdMillis' be logged?",			"3.1.2", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty logXaCommands = new BooleanConnectionProperty(			"logXaCommands",			false,			"Should the driver log XA commands sent by MysqlXaConnection to the server," +			" at the DEBUG level of logging?",			"5.0.5", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty maintainTimeStats = new BooleanConnectionProperty(			"maintainTimeStats",			true,			"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.", "3.1.9", PERFORMANCE_CATEGORY,			Integer.MAX_VALUE);	private boolean maintainTimeStatsAsBoolean = true;	private IntegerConnectionProperty maxQuerySizeToLog = new IntegerConnectionProperty(			"maxQuerySizeToLog",			2048,			0,			Integer.MAX_VALUE,			"Controls the maximum length/size of a query that will get logged when profiling or tracing",			"3.1.3", DEBUGING_PROFILING_CATEGORY, 4);	private IntegerConnectionProperty maxReconnects = new IntegerConnectionProperty(			"maxReconnects",			3,			1,			Integer.MAX_VALUE,			"Maximum number of reconnects to attempt if autoReconnect is true, default is '3'.",			"1.1", HA_CATEGORY, 4);	private IntegerConnectionProperty maxRows = new IntegerConnectionProperty(			"maxRows", -1, -1, Integer.MAX_VALUE,			"The maximum number of rows to return "					+ " (0, the default means return all rows).",			"all versions", MISC_CATEGORY, Integer.MIN_VALUE);	private int maxRowsAsInt = -1;	private IntegerConnectionProperty metadataCacheSize = new IntegerConnectionProperty(			"metadataCacheSize",			50,			1,			Integer.MAX_VALUE,			"The number of queries to cache"					+ "ResultSetMetadata for if cacheResultSetMetaData is set to 'true' (default 50)",			"3.1.1", PERFORMANCE_CATEGORY, 5);	private BooleanConnectionProperty noAccessToProcedureBodies = new BooleanConnectionProperty(			"noAccessToProcedureBodies",			false,			"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?",			"5.0.3", MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty noDatetimeStringSync = new BooleanConnectionProperty(			"noDatetimeStringSync",			false,			"Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())",			"3.1.7", MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty noTimezoneConversionForTimeType = new BooleanConnectionProperty(			"noTimezoneConversionForTimeType",			false,			"Don't convert TIME values using the server timezone if 'useTimezone'='true'",			"5.0.0", MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty nullCatalogMeansCurrent = new BooleanConnectionProperty(			"nullCatalogMeansCurrent",			true,			"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)",			"3.1.8", MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty nullNamePatternMatchesAll = new BooleanConnectionProperty(			"nullNamePatternMatchesAll",			true,			"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)",			"3.1.8", MISC_CATEGORY, Integer.MIN_VALUE);	private IntegerConnectionProperty packetDebugBufferSize = new IntegerConnectionProperty(			"packetDebugBufferSize",			20,			0,			Integer.MAX_VALUE,			"The maximum number of packets to retain when 'enablePacketDebug' is true",			"3.1.3", DEBUGING_PROFILING_CATEGORY, 7);	private BooleanConnectionProperty padCharsWithSpace = new BooleanConnectionProperty(			"padCharsWithSpace",			false,			"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)?",			"5.0.6",			MISC_CATEGORY,			Integer.MIN_VALUE);	private BooleanConnectionProperty paranoid = new BooleanConnectionProperty(			"paranoid",			false,			"Take measures to prevent exposure sensitive information in error messages and clear "					+ "data structures holding sensitive data when possible? (defaults to 'false')",			"3.0.1", SECURITY_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty pedantic = new BooleanConnectionProperty(			"pedantic", false, "Follow the JDBC spec to the letter.", "3.0.0",			MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty pinGlobalTxToPhysicalConnection = new BooleanConnectionProperty(			"pinGlobalTxToPhysicalConnection", false, "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",			"5.0.1", MISC_CATEGORY, Integer.MIN_VALUE);	private BooleanConnectionProperty populateInsertRowWithDefaultValues = new BooleanConnectionProperty(			"populateInsertRowWithDefaultValues", false,			"When using ResultSets that are CONCUR_UPDATABLE, should the driver pre-poulate " +			"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.",			"5.0.5", MISC_CATEGORY, Integer.MIN_VALUE);	private IntegerConnectionProperty preparedStatementCacheSize = new IntegerConnectionProperty(			"prepStmtCacheSize", 25, 0, Integer.MAX_VALUE,			"If prepared statement caching is enabled, "					+ "how many prepared statements should be cached?",			"3.0.10", PERFORMANCE_CATEGORY, 10);	private IntegerConnectionProperty preparedStatementCacheSqlLimit = new IntegerConnectionProperty(			"prepStmtCacheSqlLimit",			256,			1,			Integer.MAX_VALUE,			"If prepared statement caching is enabled, "					+ "what's the largest SQL the driver will cache the parsing for?",			"3.0.10", PERFORMANCE_CATEGORY, 11);	private BooleanConnectionProperty processEscapeCodesForPrepStmts =		new BooleanConnectionProperty("processEscapeCodesForPrepStmts",				true,				"Should the driver process escape codes in queries that are prepared?",				"3.1.12",				MISC_CATEGORY, Integer.MIN_VALUE);	private StringConnectionProperty profileSql = new StringConnectionProperty(			"profileSql",			null,			"Deprecated, use 'profileSQL' instead. Trace queries and their execution/fetch times on STDERR (true/false) defaults to 'false'",			"2.0.14", DEBUGING_PROFILING_CATEGORY, 3);	private BooleanConnectionProperty profileSQL = new BooleanConnectionProperty(			"profileSQL",			false,			"Trace queries and their execution/fetch times to the configured logger (true/false) defaults to 'false'",			"3.1.0", DEBUGING_PROFILING_CATEGORY, 1);	private boolean profileSQLAsBoolean = false;	private StringConnectionProperty propertiesTransform = new StringConnectionProperty(			NonRegisteringDriver.PROPERTIES_TRANSFORM_KEY,			null,			"An implementation of com.mysql.jdbc.ConnectionPropertiesTransform that the driver will use to modify URL properties passed to the driver before attempting a connection",			"3.1.4", CONNECTION_AND_AUTH_CATEGORY, Integer.MIN_VALUE);	private IntegerConnectionProperty queriesBeforeRetryMaster = new IntegerConnectionProperty(			"queriesBeforeRetryMaster",			50,			1,			Integer.MAX_VALUE,			"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.",			"3.0.2", HA_CATEGORY, 7);	private BooleanConnectionProperty reconnectAtTxEnd = new BooleanConnectionProperty(			"reconnectAtTxEnd", false,			"If autoReconnect is set to true, should the driver attempt reconnections"					+ "at the end of every transaction?", "3.0.10",			HA_CATEGORY, 4);	private boolean reconnectTxAtEndAsBoolean = false;	private BooleanConnectionProperty relaxAutoCommit = new BooleanConnectionProperty(			"relaxAutoCommit",			false,			"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')?",			"2.0.13", MISC_CATEGORY, Integer.MIN_VALUE);	private IntegerConnectionProperty reportMetricsIntervalMillis = new IntegerConnectionProperty(			"reportMetricsIntervalMillis",			30000,			0,			Integer.MAX_VALUE,			"If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?",			"3.1.2", DEBUGING_PROFILING_CATEGORY, 3);	private BooleanConnectionProperty requireSSL = new BooleanConnectionProperty(			"requireSSL", false,			"Require SSL connection if useSSL=true? (defaults to 'false').",			"3.1.0", SECURITY_CATEGORY, 3);	private StringConnectionProperty resourceId = new StringConnectionProperty(			"resourceId",			null, "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",			"5.0.1",			HA_CATEGORY,			Integer.MIN_VALUE);	private IntegerConnectionProperty resultSetSizeThreshold = new IntegerConnectionProperty("resultSetSizeThreshold", 100,