?? connectionproperties.java
字號:
"If the usage advisor is enabled, how many rows should a result set contain before the driver warns that it " + " is suspiciously large?", "5.0.5", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE); 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 rewriteBatchedStatements = new BooleanConnectionProperty( "rewriteBatchedStatements", false, "Should the driver use multiqueries (irregardless of the setting of \"allowMultiQueries\") as well as " + "rewriting of prepared statements for INSERT and REPLACE into multi-value inserts/replaces 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.\n\n" + "Notice that if you don't specify stream lengths when using PreparedStatement.set*Stream()," + "the driver won't be able to determine the optimium number of parameters per batch and you might receive " + "an error from the driver that the resultant packet is too large.\n\n" + "Statement.getGeneratedKeys() for these rewritten statements only works when the entire " + "batch includes INSERT statements.", "3.1.13", PERFORMANCE_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 LongConnectionProperty slowQueryThresholdNanos = new LongConnectionProperty( "slowQueryThresholdNanos", 0, "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.", "5.0.7", DEBUGING_PROFILING_CATEGORY, 10); 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 overrideSupportsIntegrityEnhancementFacility = new BooleanConnectionProperty("overrideSupportsIntegrityEnhancementFacility", false, "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)?", "3.1.12", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty tcpNoDelay = new BooleanConnectionProperty( StandardSocketFactory.TCP_NO_DELAY_PROPERTY_NAME, Boolean.valueOf(StandardSocketFactory.TCP_NO_DELAY_DEFAULT_VALUE).booleanValue(), "If connecting using TCP/IP, should the driver set SO_TCP_NODELAY (disabling the Nagle Algorithm)?", "5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty tcpKeepAlive = new BooleanConnectionProperty( StandardSocketFactory.TCP_KEEP_ALIVE_PROPERTY_NAME, Boolean.valueOf(StandardSocketFactory.TCP_KEEP_ALIVE_DEFAULT_VALUE).booleanValue(), "If connecting using TCP/IP, should the driver set SO_KEEPALIVE?", "5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); private IntegerConnectionProperty tcpRcvBuf = new IntegerConnectionProperty( StandardSocketFactory.TCP_RCV_BUF_PROPERTY_NAME, Integer.parseInt(StandardSocketFactory.TCP_RCV_BUF_DEFAULT_VALUE), 0, Integer.MAX_VALUE, "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)", "5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); private IntegerConnectionProperty tcpSndBuf = new IntegerConnectionProperty( StandardSocketFactory.TCP_SND_BUF_PROPERTY_NAME, Integer.parseInt(StandardSocketFactory.TCP_SND_BUF_DEFAULT_VALUE), 0, Integer.MAX_VALUE, "If connecting using TCP/IP, shuold the driver set SO_SND_BUF to the given value? " + "The default value of '0', means use the platform default value for this property)", "5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); private IntegerConnectionProperty tcpTrafficClass = new IntegerConnectionProperty( StandardSocketFactory.TCP_TRAFFIC_CLASS_PROPERTY_NAME, Integer.parseInt(StandardSocketFactory.TCP_TRAFFIC_CLASS_DEFAULT_VALUE), 0, 255, "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.", "5.0.7", NETWORK_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 treatUtilDateAsTimestamp = new BooleanConnectionProperty( "treatUtilDateAsTimestamp", true, "Should the driver treat java.util.Date as a TIMESTAMP for the purposes of PreparedStatement.setObject()?", "5.0.5", MISC_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 useConfigs = 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 useCursorFetch = new BooleanConnectionProperty( "useCursorFetch", false, "If connected to MySQL > 5.0.2, and setFetchSize() > 0 on a statement, should " + " that statement use cursor-based fetching to retrieve rows?", "5.0.0", PERFORMANCE_CATEGORY, Integer.MAX_VALUE); private BooleanConnectionProperty useDynamicCharsetInfo = new BooleanConnectionProperty( "useDynamicCharsetInfo", true, "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?" + "(this only affects the \"padCharsWithSpace\" configuration property and the " + "ResultSetMetaData.getColumnDisplayWidth() method)." , "5.0.6", PERFORMANCE_CATEGORY, Integer.MIN_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 useFastDateParsing = new BooleanConnectionProperty( "useFastDateParsing", true, "Use internal String->Date/Time/Teimstamp conversion routines to avoid excessive object creation?", "5.0.5", 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 useInformationSchema = new BooleanConnectionProperty( "useInformationSchema", false, "When connected to MySQL-5.0.7 or newer, should the driver use the INFORMATION_SCHEMA to " + " derive information used by DatabaseMetaData?", "5.0.0", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useJDBCCompliantTimezoneShift = new BooleanConnectionProperty( "useJDBCCompliantTimezoneShift", false, "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.)", "5.0.0", 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() 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?", "3.1.7", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useNanosForElapsedTime = new BooleanConnectionProperty( "useNanosForElapsedTime", false, "For profiling/debugging functionality that measures elapsed time, should the driver " + "try to use nanoseconds resolution if available (JDK >= 1.5)?", "5.0.7", DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useOldAliasMetadataBehavior = new BooleanConnectionProperty( "useOldAliasMetadataBehavior", true, "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?", "5.0.4", MISC_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", true, "Don't prepend 'standard' SQLState error messages to error messages returned by the server.", "3.0.15", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useReadAheadInput = new BooleanConnectionProperty( "useReadAheadInput", true, "Use newer, optimized non-blocking, buffered input stream when reading from the server?", "3.1.5", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useSqlStateCodes = new BooleanConnectionProperty( "useSqlStateCodes", true, "Use SQL Standard state codes instead of 'legacy' X/Open/SQL state codes (true/false), default is 'true'", "3.1.3", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useSSL = new BooleanConnectionProperty( "useSSL", false, "Use SSL when communicating with the server (true/false), defaults to 'false'", "3.0.2", SECURITY_CATEGORY, 2); private BooleanConnectionProperty useSSPSCompatibleTimezoneShift = new BooleanConnectionProperty( "useSSPSCompatibleTimezoneShift", false, "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.", "5.0.5", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useStreamLengthsInPrepStmts = new BooleanConnectionProperty( "useStreamLengthsInPrepStmts", true, "Honor stream length parameter in " + "PreparedStatement/ResultSet.setXXXStream() method calls (true/false, defaults to 'true')?", "3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useTimezone = new BooleanConnectionProperty( "useTimezone", false, "Convert time/date types between client and server timezones (true/false, defaults to 'false')?", "3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); private BooleanConnectionProperty useUltraDevWorkAround = new BooleanConnectionProperty( "ultraDevHack", false, "Create PreparedSta
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -