邯郸房地产网站建设,wordpress消除,智联招聘网站怎么做微招聘信息,wordpress highlight这是一些简单的步骤#xff0c;可帮助您使用Groovy在MySQL数据库上完全入门Quartz Scheduler。 以下脚本可让您使用外部文件快速尝试不同的Quartz配置设置。 第一步是使用表设置数据库。 假设您已经安装了MySQL#xff0c;并且有权创建数据库和表。 bash mysql -u root … 这是一些简单的步骤可帮助您使用Groovy在MySQL数据库上完全入门Quartz Scheduler。 以下脚本可让您使用外部文件快速尝试不同的Quartz配置设置。 第一步是使用表设置数据库。 假设您已经安装了MySQL并且有权创建数据库和表。 bash mysql -u root -psql create database quartz2;
sql create user quartz2localhost identified by quartz2123;
sql grant all privileges on quartz2.* to quartz2localhost;
sql exit;bash mysql -u root -p quartz2 /path/to/quartz-dist/docs/dbTables/tables_mysql.sql 可以从Quartz发行版下载中找到tables_mysql.sql 或直接从其源代码中找到 。 数据库启动后您需要编写一些代码来启动Quartz Scheduler。 这是一个简单的Groovy脚本quartzServer.groovy 它将作为小型调度程序服务器运行。 // Run Quartz Scheduler as a server
// Author: Author: Zemian Deng, Date: 2012-12-15_16:46:09
GrabConfig(systemClassLoadertrue)
Grab(mysql:mysql-connector-java:5.1.22)
Grab(org.slf4j:slf4j-simple:1.7.1)
Grab(org.quartz-scheduler:quartz:2.1.6)
import org.quartz.*
import org.quartz.impl.*
import org.quartz.jobs.*config args.length 0 ? args[0] : quartz.properties
scheduler new StdSchedulerFactory(config).getScheduler()
scheduler.start()// Register shutdown
addShutdownHook {scheduler.shutdown()
}// Quartz has its own thread, so now put this script thread to sleep until
// user hit CTRLC
while (!scheduler.isShutdown()) {Thread.sleep(Long.MAX_VALUE)
} 现在您只需要一个如下所示的配置文件quartz-mysql.properties # Main Quartz configuration
org.quartz.scheduler.skipUpdateCheck true
org.quartz.scheduler.instanceName DatabaseScheduler
org.quartz.scheduler.instanceId NON_CLUSTERED
org.quartz.scheduler.jobFactory.class org.quartz.simpl.SimpleJobFactory
org.quartz.jobStore.class org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.dataSource quartzDataSource
org.quartz.jobStore.tablePrefix QRTZ_
org.quartz.threadPool.class org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount 5# JobStore: JDBC jobStoreTX
org.quartz.dataSource.quartzDataSource.driver com.mysql.jdbc.Driver
org.quartz.dataSource.quartzDataSource.URL jdbc:mysql://localhost:3306/quartz2
org.quartz.dataSource.quartzDataSource.user quartz2
org.quartz.dataSource.quartzDataSource.password quartz2123
org.quartz.dataSource.quartzDataSource.maxConnections 8 您可以照常运行Groovy脚本 bash groovy quartzServer.groovy quartz-mysql.properties
Dec 15, 2012 6:20:26 PM com.mchange.v2.log.MLog INFO: MLog clients using java 1.4 standard logging.
Dec 15, 2012 6:20:27 PM com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace:10]
[main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
[main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
[main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.1.6 created.
[main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.quartz.simpl.SimpleJobFactory1a40247
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Using thread monitor-based data access locking (synchronization).
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - JobStoreTX initialized.
[main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.1.6) DatabaseScheduler with instanceId NON_CLUSTEREDScheduler class: org.quartz.core.QuartzScheduler - running locally.NOT STARTED.Currently in standby mode.Number of jobs executed: 0Using thread pool org.quartz.simpl.SimpleThreadPool - with 5 threads.Using job-store org.quartz.impl.jdbcjobstore.JobStoreTX - which supports persistence. and is not clustered.[main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler DatabaseScheduler initialized from the specified file : quartz-mysql.properties from the class resource path.
[main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.1.6
Dec 15, 2012 6:20:27 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement - 3, acquireRetryAttempts
- 30, acquireRetryDelay - 1000, autoCommitOnClose - false, automaticTestTable - null, breakAfterAcquireFailure - false, checkoutTimeout - 0, connectionCustomizerClassName - null, connectionTesterClassName - com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName - 1hge16k8r18mveoq1iqtotg|1486306, debugUnreturnedConnectionStackTraces - fals
e, description - null, driverClass - com.mysql.jdbc.Driver, factoryClassLocation - null, forceIgnoreUnresolvedTransactions - false, identityToken - 1hge16k8r18mveoq1iqtotg|1486306, idleConnectionTestPeriod - 0, initialPoolSize - 3, jdbcUrl - jdbc:mysql://localhost:3306/quartz2, lastAcquisitionFailureDefaultUser - null, maxAdministrativeTaskTime - 0
, maxConnectionAge - 0, maxIdleTime - 0, maxIdleTimeExcessConnections - 0, maxPoolSize - 8, maxStatements - 0, maxStatementsPerConnection - 120, minPoolSize - 1, numHelperThreads - 3, numThreadsAwaitingCheckoutDefaultUser - 0, pref
erredTestQuery - null, properties - {user******, password******}, propertyCycle - 0, testConnectionOnCheckin - false, testConnectionOnCheckout - false, unreturnedConnectionTimeout - 0, usesTraditionalReflectiveProxies - false ]
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Freed 0 triggers from acquired / blocked state.[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Recovering 0 jobs that were in-progress at the time of the last shut-down.
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Recovery complete.
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Removed 0 complete triggers.
[main] INFO org.quartz.impl.jdbcjobstore.JobStoreTX - Removed 0 stale fired job entries.
[main] INFO org.quartz.core.QuartzScheduler - Scheduler DatabaseScheduler_$_NON_CLUSTERED started.... CTRLC
[Thread-6] INFO org.quartz.core.QuartzScheduler - Scheduler DatabaseScheduler_$_NON_CLUSTERED shutting down.
[Thread-6] INFO org.quartz.core.QuartzScheduler - Scheduler DatabaseScheduler_$_NON_CLUSTERED paused.
[Thread-6] INFO org.quartz.core.QuartzScheduler - Scheduler DatabaseScheduler_$_NON_CLUSTERED shutdown complete. 以上就是上述设置的完整过程。 继续并使用不同的配置。 阅读http://quartz-scheduler.org/documentation/quartz-2.1.x/configuration以获得更多详细信息。 在这里我将发布一些更简单的配置使您开始使用常用的配置集 MySQL群集启用的配置。 这样您可以启动一个或多个Shell终端并使用相同的配置运行quartzServer.groovy不同实例。 所有的石英调度程序实例都应将它们自己群集起来并平均分配您的作业。 # Main Quartz configuration
org.quartz.scheduler.skipUpdateCheck true
org.quartz.scheduler.instanceName DatabaseClusteredScheduler
org.quartz.scheduler.instanceId AUTO
org.quartz.scheduler.jobFactory.class org.quartz.simpl.SimpleJobFactory
org.quartz.jobStore.class org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.dataSource quartzDataSource
org.quartz.jobStore.tablePrefix QRTZ_
org.quartz.jobStore.isClustered true
org.quartz.threadPool.class org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount 5# JobStore: JDBC jobStoreTX
org.quartz.dataSource.quartzDataSource.driver com.mysql.jdbc.Driver
org.quartz.dataSource.quartzDataSource.URL jdbc:mysql://localhost:3306/quartz2
org.quartz.dataSource.quartzDataSource.user quartz2
org.quartz.dataSource.quartzDataSource.password quartz2123
org.quartz.dataSource.quartzDataSource.maxConnections 8 这是一个简单的内存调度程序的另一个配置集。 # Main Quartz configuration
org.quartz.scheduler.skipUpdateCheck true
org.quartz.scheduler.instanceName InMemoryScheduler
org.quartz.scheduler.jobFactory.class org.quartz.simpl.SimpleJobFactory
org.quartz.threadPool.class org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount 5 现在如果您需要对Quartz进行更高级的UI管理请尝试使用MySchedule 。 调度愉快 参考 A程序员杂志博客上的JCG合作伙伴 Zemian Deng从MySQL数据库上的Quartz Scheduler入门开始 。 翻译自: https://www.javacodegeeks.com/2012/12/getting-started-with-quartz-scheduler-on-mysql-database.html