connectionproperties.java

mysql的jdbc驱动

			"emulateUnsupportedPstmts",
			true,
			"Should the driver detect prepared statements that are not supported by the server, and "
					+ "replace them with client-side emulated versions?",
			"3.1.7", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty enableDeprecatedAutoreconnect = new BooleanConnectionProperty(
			"enableDeprecatedAutoreconnect",
			false,
			"Auto-reconnect functionality is deprecated starting with version 3.2, and will be removed in version 3.3. Set this "
					+ "property to 'true' to disable the check for the feature being configured.",
			"3.2.1", HA_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty enablePacketDebug = new BooleanConnectionProperty(
			"enablePacketDebug",
			false,
			"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",
			"3.1.3", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty explainSlowQueries = new BooleanConnectionProperty(
			"explainSlowQueries",
			false,
			"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?",
			"3.1.2", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);

	/** When failed-over, set connection to read-only? */
	private BooleanConnectionProperty failOverReadOnly = new BooleanConnectionProperty(
			"failOverReadOnly",
			true,
			"When failing over in autoReconnect mode, should the connection be set to 'read-only'?",
			"3.0.12", HA_CATEGORY, 2);

	private BooleanConnectionProperty gatherPerformanceMetrics = new BooleanConnectionProperty(
			"gatherPerfMetrics",
			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 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 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 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 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 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 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 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 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 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 BooleanConnectionProperty retainStatementAfterResultSetClose = new BooleanConnectionProperty(
			"retainStatementAfterResultSetClose",
			false,
			"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.",
			"3.1.11", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty rollbackOnPooledClose = new BooleanConnectionProperty(
			"rollbackOnPooledClose",
			true,
			"Should the driver issue a rollback() when the logical connection in a pool is closed?",
			"3.0.15", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty roundRobinLoadBalance = new BooleanConnectionProperty(
			"roundRobinLoadBalance",
			false,
			"When autoReconnect is enabled, and failoverReadonly is false, should we pick hosts to connect to on a round-robin basis?",
			"3.1.2", HA_CATEGORY, 5);

	private BooleanConnectionProperty runningCTS13 = new BooleanConnectionProperty(
			"runningCTS13",
			false,
			"Enables workarounds for bugs in Sun's JDBC compliance testsuite version 1.3",
			"3.1.7", MISC_CATEGORY, Integer.MIN_VALUE);

	private IntegerConnectionProperty secondsBeforeRetryMaster = new IntegerConnectionProperty(
			"secondsBeforeRetryMaster",
			30,
			1,
			Integer.MAX_VALUE,
			"How long should the driver wait, when failed over, before attempting "
					+ "to reconnect to the master server? Whichever condition is met first, "
					+ "'queriesBeforeRetryMaster' or 'secondsBeforeRetryMaster' will cause an "
					+ "attempt to be made to reconnect to the master. Time in seconds, defaults to 30",
			"3.0.2", HA_CATEGORY, 8);

	private StringConnectionProperty serverTimezone = new StringConnectionProperty(
			"serverTimezone",
			null,
			"Override detection/mapping of timezone. Used when timezone from server doesn't map to Java timezone",
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE);

	private StringConnectionProperty sessionVariables = new StringConnectionProperty(
			"sessionVariables", null,
			"A comma-separated list of name/value pairs to be sent as SET SESSION ... to "
					+ " the server when the driver connects.", "3.1.8",
			MISC_CATEGORY, Integer.MAX_VALUE);

	private IntegerConnectionProperty slowQueryThresholdMillis = new IntegerConnectionProperty(
			"slowQueryThresholdMillis",
			2000,
			0,
			Integer.MAX_VALUE,
			"If 'logSlowQueries' is enabled, how long should a query (in ms) before it is logged as 'slow'?",
			"3.1.2", DEBUGING_PROFILING_CATEGORY, 9);

	private StringConnectionProperty socketFactoryClassName = new StringConnectionProperty(
			"socketFactory",
			StandardSocketFactory.class.getName(),
			"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.",
			"3.0.3", CONNECTION_AND_AUTH_CATEGORY, 4);

	private IntegerConnectionProperty socketTimeout = new IntegerConnectionProperty(
			"socketTimeout",
			0,
			0,
			Integer.MAX_VALUE,
			"Timeout on network socket operations (0, the default means no timeout).",
			"3.0.1", CONNECTION_AND_AUTH_CATEGORY, 10);

	private BooleanConnectionProperty strictFloatingPoint = new BooleanConnectionProperty(
			"strictFloatingPoint", false,
			"Used only in older versions of compliance test", "3.0.0",
			MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty strictUpdates = new BooleanConnectionProperty(
			"strictUpdates",
			true,
			"Should the driver do strict checking (all primary keys selected) of updatable result sets (true, false, defaults to 'true')?",
			"3.0.4", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty tinyInt1isBit = new BooleanConnectionProperty(
			"tinyInt1isBit",
			true,
			"Should the driver treat the datatype TINYINT(1) as the BIT type "
					+ "(because the server silently converts BIT -> TINYINT(1) when creating tables)?",
			"3.0.16", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty traceProtocol = new BooleanConnectionProperty(
			"traceProtocol", false,
			"Should trace-level network protocol be logged?", "3.1.2",
			DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty transformedBitIsBoolean = new BooleanConnectionProperty(
			"transformedBitIsBoolean",
			false,
			"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?",
			"3.1.9", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty useCompression = new BooleanConnectionProperty(
			"useCompression",
			false,
			"Use zlib compression when communicating with the server (true/false)? Defaults to 'false'.",
			"3.0.17", CONNECTION_AND_AUTH_CATEGORY, Integer.MIN_VALUE);

	private StringConnectionProperty useConfig = new StringConnectionProperty(
			"useConfigs",
			null,
			"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.",
			"3.1.5", CONNECTION_AND_AUTH_CATEGORY, Integer.MAX_VALUE);

	private BooleanConnectionProperty useFastIntParsing = new BooleanConnectionProperty(
			"useFastIntParsing",
			true,
			"Use internal String->Integer conversion routines to avoid excessive object creation?",
			"3.1.4", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty useHostsInPrivileges = new BooleanConnectionProperty(
			"useHostsInPrivileges",
			true,
			"Add '@hostname' to users in DatabaseMetaData.getColumn/TablePrivileges() (true/false), defaults to 'true'.",
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty useLocalSessionState = new BooleanConnectionProperty(
			"useLocalSessionState",
			false,
			"Should the driver refer to the internal values of autocommit and transaction isolation that are set "
					+ " by Connection.setAutoCommit() and Connection.setTransactionIsolation(), rather than querying the database?",
			"3.1.7", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty useNewIo = new BooleanConnectionProperty(
			"useNewIO",
			false,
			"Should the driver use the java.nio.* interfaces for network communication (true/false), defaults to 'false'",
			"3.1.0", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty useOldUTF8Behavior = new BooleanConnectionProperty(
			"useOldUTF8Behavior",
			false,
			"Use the UTF-8 behavior the driver did when communicating with 4.0 and older servers",
			"3.1.6", MISC_CATEGORY, Integer.MIN_VALUE);

	private boolean useOldUTF8BehaviorAsBoolean = false;

	private BooleanConnectionProperty useOnlyServerErrorMessages = new BooleanConnectionProperty(
			"useOnlyServerErrorMessages",