connectionpropertiesimpl.java

mysql5.0 JDBC 驱动 放在glassfish或者tomcat的lib文件夹下就可以了

			"secondsBeforeRetryMaster", //$NON-NLS-1$
			30,
			1,
			Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.secondsBeforeRetryMaster"), //$NON-NLS-1$
			"3.0.2", HA_CATEGORY, 8); //$NON-NLS-1$

	private IntegerConnectionProperty selfDestructOnPingSecondsLifetime = new IntegerConnectionProperty(
			"selfDestructOnPingSecondsLifetime",
			0,
			0,
			Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.selfDestructOnPingSecondsLifetime"),
			"5.1.6", HA_CATEGORY, Integer.MAX_VALUE);
	
	private IntegerConnectionProperty selfDestructOnPingMaxOperations = new IntegerConnectionProperty(
			"selfDestructOnPingMaxOperations",
			0,
			0,
			Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.selfDestructOnPingMaxOperations"),
			"5.1.6", HA_CATEGORY, Integer.MAX_VALUE);
			
	private StringConnectionProperty serverTimezone = new StringConnectionProperty(
			"serverTimezone", //$NON-NLS-1$
			null,
			Messages.getString("ConnectionProperties.serverTimezone"), //$NON-NLS-1$
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private StringConnectionProperty sessionVariables = new StringConnectionProperty(
			"sessionVariables", null, //$NON-NLS-1$
			Messages.getString("ConnectionProperties.sessionVariables"), "3.1.8", //$NON-NLS-1$ //$NON-NLS-2$
			MISC_CATEGORY, Integer.MAX_VALUE);

	private IntegerConnectionProperty slowQueryThresholdMillis = new IntegerConnectionProperty(
			"slowQueryThresholdMillis", //$NON-NLS-1$
			2000,
			0,
			Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.slowQueryThresholdMillis"), //$NON-NLS-1$
			"3.1.2", DEBUGING_PROFILING_CATEGORY, 9); //$NON-NLS-1$
	
	private LongConnectionProperty slowQueryThresholdNanos = new LongConnectionProperty(
			"slowQueryThresholdNanos", //$NON-NLS-1$
			0,
			Messages.getString("ConnectionProperties.slowQueryThresholdNanos"), //$NON-NLS-1$
			"5.0.7", //$NON-NLS-1$
			DEBUGING_PROFILING_CATEGORY,
			10);
	
	private StringConnectionProperty socketFactoryClassName = new StringConnectionProperty(
			"socketFactory", //$NON-NLS-1$
			StandardSocketFactory.class.getName(),
			Messages.getString("ConnectionProperties.socketFactory"), //$NON-NLS-1$
			"3.0.3", CONNECTION_AND_AUTH_CATEGORY, 4); //$NON-NLS-1$

	private IntegerConnectionProperty socketTimeout = new IntegerConnectionProperty(
			"socketTimeout", //$NON-NLS-1$
			0,
			0,
			Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.socketTimeout"), //$NON-NLS-1$
			"3.0.1", CONNECTION_AND_AUTH_CATEGORY, 10); //$NON-NLS-1$
	
	private StringConnectionProperty statementInterceptors = new StringConnectionProperty("statementInterceptors", //$NON-NLS-1$
			null, Messages.getString("ConnectionProperties.statementInterceptors"), "5.1.1", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$ //$NON-NLS-2$
	
	private BooleanConnectionProperty strictFloatingPoint = new BooleanConnectionProperty(
			"strictFloatingPoint", false, //$NON-NLS-1$
			Messages.getString("ConnectionProperties.strictFloatingPoint"), "3.0.0", //$NON-NLS-1$ //$NON-NLS-2$
			MISC_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty strictUpdates = new BooleanConnectionProperty(
			"strictUpdates", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.strictUpdates"), //$NON-NLS-1$
			"3.0.4", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty overrideSupportsIntegrityEnhancementFacility =
		new BooleanConnectionProperty("overrideSupportsIntegrityEnhancementFacility", //$NON-NLS-1$
				false,
				Messages.getString("ConnectionProperties.overrideSupportsIEF"), //$NON-NLS-1$
				"3.1.12", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty tcpNoDelay = new BooleanConnectionProperty(
			StandardSocketFactory.TCP_NO_DELAY_PROPERTY_NAME,
			Boolean.valueOf(StandardSocketFactory.TCP_NO_DELAY_DEFAULT_VALUE).booleanValue(),
			Messages.getString("ConnectionProperties.tcpNoDelay"), //$NON-NLS-1$
			"5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty tcpKeepAlive = new BooleanConnectionProperty(
			StandardSocketFactory.TCP_KEEP_ALIVE_PROPERTY_NAME,
			Boolean.valueOf(StandardSocketFactory.TCP_KEEP_ALIVE_DEFAULT_VALUE).booleanValue(),
			Messages.getString("ConnectionProperties.tcpKeepAlive"), //$NON-NLS-1$
			"5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private IntegerConnectionProperty tcpRcvBuf = new IntegerConnectionProperty(
			StandardSocketFactory.TCP_RCV_BUF_PROPERTY_NAME,
			Integer.parseInt(StandardSocketFactory.TCP_RCV_BUF_DEFAULT_VALUE),
			0, Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.tcpSoRcvBuf"), //$NON-NLS-1$
			"5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private IntegerConnectionProperty tcpSndBuf = new IntegerConnectionProperty(
			StandardSocketFactory.TCP_SND_BUF_PROPERTY_NAME,
			Integer.parseInt(StandardSocketFactory.TCP_SND_BUF_DEFAULT_VALUE),
			0, Integer.MAX_VALUE,
			Messages.getString("ConnectionProperties.tcpSoSndBuf"), //$NON-NLS-1$
			"5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
			
	private IntegerConnectionProperty tcpTrafficClass = new IntegerConnectionProperty(
			StandardSocketFactory.TCP_TRAFFIC_CLASS_PROPERTY_NAME,
			Integer.parseInt(StandardSocketFactory.TCP_TRAFFIC_CLASS_DEFAULT_VALUE),
			0, 255,
			Messages.getString("ConnectionProperties.tcpTrafficClass"), //$NON-NLS-1$
			"5.0.7", NETWORK_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty tinyInt1isBit = new BooleanConnectionProperty(
			"tinyInt1isBit", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.tinyInt1isBit"), //$NON-NLS-1$
			"3.0.16", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty traceProtocol = new BooleanConnectionProperty(
			"traceProtocol", false, //$NON-NLS-1$
			Messages.getString("ConnectionProperties.traceProtocol"), "3.1.2", //$NON-NLS-1$ //$NON-NLS-2$
			DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);

	private BooleanConnectionProperty treatUtilDateAsTimestamp = new BooleanConnectionProperty(
			"treatUtilDateAsTimestamp", true, //$NON-NLS-1$
			Messages.getString("ConnectionProperties.treatUtilDateAsTimestamp"), //$NON-NLS-1$
			"5.0.5", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty transformedBitIsBoolean = new BooleanConnectionProperty(
			"transformedBitIsBoolean", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.transformedBitIsBoolean"), //$NON-NLS-1$
			"3.1.9", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useBlobToStoreUTF8OutsideBMP = new BooleanConnectionProperty(
			"useBlobToStoreUTF8OutsideBMP",
			false,
			Messages.getString("ConnectionProperties.useBlobToStoreUTF8OutsideBMP"), //$NON-NLS-1$
			"5.1.3", MISC_CATEGORY, 128);
	
	private StringConnectionProperty utf8OutsideBmpExcludedColumnNamePattern = new StringConnectionProperty(
			"utf8OutsideBmpExcludedColumnNamePattern",
			null,
			Messages.getString("ConnectionProperties.utf8OutsideBmpExcludedColumnNamePattern"), //$NON-NLS-1$
			"5.1.3", MISC_CATEGORY, 129);
	
	private StringConnectionProperty utf8OutsideBmpIncludedColumnNamePattern = new StringConnectionProperty(
			"utf8OutsideBmpIncludedColumnNamePattern",
			null,
			Messages.getString("ConnectionProperties.utf8OutsideBmpIncludedColumnNamePattern"), //$NON-NLS-1$
			"5.1.3", MISC_CATEGORY, 129);
	
	private BooleanConnectionProperty useCompression = new BooleanConnectionProperty(
			"useCompression", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useCompression"), //$NON-NLS-1$
			"3.0.17", CONNECTION_AND_AUTH_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useColumnNamesInFindColumn = new BooleanConnectionProperty(
			"useColumnNamesInFindColumn",
			false, 
			Messages.getString("ConnectionProperties.useColumnNamesInFindColumn"), //$NON-NLS-1$
			"5.1.7", MISC_CATEGORY, Integer.MAX_VALUE); //$NON-NLS-1$
	
	private StringConnectionProperty useConfigs = new StringConnectionProperty(
			"useConfigs", //$NON-NLS-1$
			null,
			Messages.getString("ConnectionProperties.useConfigs"), //$NON-NLS-1$
			"3.1.5", CONNECTION_AND_AUTH_CATEGORY, Integer.MAX_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useCursorFetch = new BooleanConnectionProperty(
			"useCursorFetch", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useCursorFetch"), //$NON-NLS-1$
			"5.0.0", PERFORMANCE_CATEGORY, Integer.MAX_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty useDynamicCharsetInfo = new BooleanConnectionProperty(
			"useDynamicCharsetInfo", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useDynamicCharsetInfo") //$NON-NLS-1$
			, "5.0.6", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty useDirectRowUnpack = new BooleanConnectionProperty(
			"useDirectRowUnpack",
			true, "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.",
			"5.1.1", PERFORMANCE_CATEGORY, Integer.MIN_VALUE);
	
	private BooleanConnectionProperty useFastIntParsing = new BooleanConnectionProperty(
			"useFastIntParsing", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useFastIntParsing"), //$NON-NLS-1$
			"3.1.4", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useFastDateParsing = new BooleanConnectionProperty(
			"useFastDateParsing", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useFastDateParsing"), //$NON-NLS-1$
			"5.0.5", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty useHostsInPrivileges = new BooleanConnectionProperty(
			"useHostsInPrivileges", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useHostsInPrivileges"), //$NON-NLS-1$
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	private BooleanConnectionProperty useInformationSchema = new BooleanConnectionProperty(
			"useInformationSchema", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useInformationSchema"), //$NON-NLS-1$
			"5.0.0", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	private BooleanConnectionProperty useJDBCCompliantTimezoneShift = new BooleanConnectionProperty(
			"useJDBCCompliantTimezoneShift", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useJDBCCompliantTimezoneShift"), //$NON-NLS-1$
			"5.0.0", //$NON-NLS-1$
			MISC_CATEGORY, Integer.MIN_VALUE);
	
	private BooleanConnectionProperty useLocalSessionState = new BooleanConnectionProperty(
			"useLocalSessionState", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useLocalSessionState"), //$NON-NLS-1$
			"3.1.7", PERFORMANCE_CATEGORY, 5); //$NON-NLS-1$
	
	private BooleanConnectionProperty useLocalTransactionState = new BooleanConnectionProperty(
			"useLocalTransactionState", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useLocalTransactionState"),
			"5.1.7", PERFORMANCE_CATEGORY, 6);
	
	private BooleanConnectionProperty useLegacyDatetimeCode = new BooleanConnectionProperty(
			"useLegacyDatetimeCode",
			true,
			Messages.getString("ConnectionProperties.useLegacyDatetimeCode"),
			"5.1.6", MISC_CATEGORY, Integer.MIN_VALUE);
	
	private BooleanConnectionProperty useNanosForElapsedTime = new BooleanConnectionProperty(
			"useNanosForElapsedTime", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useNanosForElapsedTime"), //$NON-NLS-1$
			"5.0.7", //$NON-NLS-1$
			DEBUGING_PROFILING_CATEGORY, Integer.MIN_VALUE);
	
	private BooleanConnectionProperty useOldAliasMetadataBehavior = new BooleanConnectionProperty(
			"useOldAliasMetadataBehavior", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useOldAliasMetadataBehavior"), //$NON-NLS-1$
		    "5.0.4", //$NON-NLS-1$
		    MISC_CATEGORY,
		    Integer.MIN_VALUE);
	
	private BooleanConnectionProperty useOldUTF8Behavior = new BooleanConnectionProperty(
			"useOldUTF8Behavior", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useOldUtf8Behavior"), //$NON-NLS-1$
			"3.1.6", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private boolean useOldUTF8BehaviorAsBoolean = false;

	private BooleanConnectionProperty useOnlyServerErrorMessages = new BooleanConnectionProperty(
			"useOnlyServerErrorMessages", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useOnlyServerErrorMessages"), //$NON-NLS-1$
			"3.0.15", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useReadAheadInput = new BooleanConnectionProperty(
			"useReadAheadInput", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useReadAheadInput"), //$NON-NLS-1$
			"3.1.5", PERFORMANCE_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useSqlStateCodes = new BooleanConnectionProperty(
			"useSqlStateCodes", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useSqlStateCodes"), //$NON-NLS-1$
			"3.1.3", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useSSL = new BooleanConnectionProperty(
			"useSSL", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useSSL"), //$NON-NLS-1$
			"3.0.2", SECURITY_CATEGORY, 2); //$NON-NLS-1$

	private BooleanConnectionProperty useSSPSCompatibleTimezoneShift = new BooleanConnectionProperty(
			"useSSPSCompatibleTimezoneShift", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useSSPSCompatibleTimezoneShift"), //$NON-NLS-1$
			"5.0.5", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$
	
	private BooleanConnectionProperty useStreamLengthsInPrepStmts = new BooleanConnectionProperty(
			"useStreamLengthsInPrepStmts", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useStreamLengthsInPrepStmts"), //$NON-NLS-1$
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useTimezone = new BooleanConnectionProperty(
			"useTimezone", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.useTimezone"), //$NON-NLS-1$
			"3.0.2", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useUltraDevWorkAround = new BooleanConnectionProperty(
			"ultraDevHack", //$NON-NLS-1$
			false,
			Messages.getString("ConnectionProperties.ultraDevHack"), //$NON-NLS-1$
			"2.0.3", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useUnbufferedInput = new BooleanConnectionProperty(
			"useUnbufferedInput", true, //$NON-NLS-1$
			Messages.getString("ConnectionProperties.useUnbufferedInput"), //$NON-NLS-1$
			"3.0.11", MISC_CATEGORY, Integer.MIN_VALUE); //$NON-NLS-1$

	private BooleanConnectionProperty useUnicode = new BooleanConnectionProperty(
			"useUnicode", //$NON-NLS-1$
			true,
			Messages.getString("ConnectionProperties.useUnicode"), //$