Quartz 2.2.1 JDBC Connection pool parameter configuration

   /** the JDBC database driver.     */Specifies the connection driver public static final String db_driver = "DRIVER"; /** the JDBC database URL.    */connection string public static final String db_url = "URL"; /** the database user name.    */user name public static final String db_user = "user"; /** the database user password.    */Password public static final String Db_password = "PASSWORD";  /** the maximum number of the database connections to the pool. Default is 10.    */Connection pool maximum number of connections public static final String db_max_connections = "MaxConnections";     /** * The maximum number of prepared statements that would be cached per connection in the pool.        * Depending upon your JDBC Driver this could significantly help performance, or may slightly * hinder performance. * Default is +, as Quartz uses over unique statements.      0 disables the feature. * * Maximum number of precompiled statements per link cache public static final String db_max_cached_statements_per_connection = "Maxcachedstatementspercon    Nection "; /**      *The database SQL query to execute every time a connection are returned * to the pool to ensure that it is still valid.    * * Verify that the connection is available for the query statement public static final String db_validation_query = "Validationquery"; /** * The number of seconds between tests of idle connections-only enabled * If the validation query property I  S set.      Default is seconds.    */How long to verify the idle connection public static final String db_idle_validation_seconds = "Idleconnectionvalidationseconds"; /** * Whether The database SQL query to validate connections should being executed every time * a connection is RET  Rieved from the pool to ensure, it is still valid.  If false, * Then validation'll occur on check-in.      Default is false.        * * Verify Connection Availability public static final String db_validate_on_checkout = "Validateoncheckout" Whenever a connection is taken from the pool;  /** Discard connections after they has been idle this many seconds. 0 disables the feature. Default is 0.*/idle connection more than how many seconds to discard private static final String db_discard_idle_connections_seconds = "Discardidleconnectionsseconds"; /** Default Maximum number of database connections in the pool.    */Maximum number of connections public static final int default_db_max_connections = 10; /** Default Maximum number of database connections in the pool. */Default 120 precompiled statements per link cache public static final int default_db_max_cached_statements_per_connection = 120;

The Quartz connection pool configuration makes some encapsulation of the C3PO connection pool configuration, leaving it as a record.

MySQL disconnect can be set by Validateoncheckout=true + Validationquery

or set discardidleconnectionsseconds less than 8 hours to resolve.

Quartz 2.2.1 JDBC Connection pool parameter configuration