quartz 2.2.1 jdbc 連接池參數(shù)配置
/** The JDBC database driver. */指定連接驅(qū)動
public static final String DB_DRIVER = "driver";
/** The JDBC database URL. */ 連接字符串
public static final String DB_URL = "URL";
/** The database user name. */ 用戶名
public static final String DB_USER = "user";
/** The database user password. */ 密碼
public static final String DB_PASSWORD = "password";
/** The maximum number of database connections to have in the pool. Default is 10. */ 連接池最大連接數(shù)
public static final String DB_MAX_CONNECTIONS = "maxConnections";
/**
* The maximum number of prepared statements that will be cached per connection in the pool.
* Depending upon your JDBC Driver this may significantly help performance, or may slightly
* hinder performance.
* Default is 120, as Quartz uses over 100 unique statements. 0 disables the feature.
*/ 每個鏈接最多緩存多少個預編譯語句
public static final String DB_MAX_CACHED_STATEMENTS_PER_CONNECTION = "maxCachedStatementsPerConnection";
/**
* The database sql query to execute every time a connection is returned
* to the pool to ensure that it is still valid.
*/ 驗證連接是否可用的查詢語句
public static final String DB_VALIDATION_QUERY = "validationQuery";
/**
* The number of seconds between tests of idle connections - only enabled
* if the validation query property is set. Default is 50 seconds.
*/ 多久驗證空閑連接
public static final String DB_IDLE_VALIDATION_SECONDS = "idleConnectionValidationSeconds";
/**
* Whether the database sql query to validate connections should be executed every time
* a connection is retrieved from the pool to ensure that it is still valid. If false,
* then validation will occur on check-in. Default is false.
*/ 是否每次從池中取連接時,驗證連接可用性
public static final String DB_VALIDATE_ON_CHECKOUT = "validateOnCheckout";
/** Discard connections after they have been idle this many seconds. 0 disables the feature. Default is 0.*/ 空閑連接超過多少秒丟棄
private static final String DB_DISCARD_IDLE_CONNECTIONS_SECONDS = "discardIdleConnectionsSeconds";
/** Default maximum number of database connections in the pool. */ 最大連接數(shù)
public static final int DEFAULT_DB_MAX_CONNECTIONS = 10;
/** Default maximum number of database connections in the pool. */ 默認每個鏈接緩存120個預編譯語句
public static final int DEFAULT_DB_MAX_CACHED_STATEMENTS_PER_CONNECTION = 120;
quartz連接池配置對C3PO連接池配置進行了一些封裝, 留作記錄。
mysql 斷開連接可以通過設(shè)置 validateOnCheckout=true + validationQuery
或者設(shè)置discardIdleConnectionsSeconds 少于8小時解決。

浙公網(wǎng)安備 33010602011771號