CODEWITHSUNDEEP
databasespringquartz-schedulerquartz
user2380811
user2380811

Reputation: 55

Quartz scheduler is continuously opening and closing database connection

I am using JobStoreTX(JDBC jobstore) jobstore to achieve clustering, but my problem is that scheduler is continuously opening and closing the database connection. at least 10 times in a second.

please let me know what property should i set to get connection from connection pool only. Thanks in advance

Upvotes: 1

Views: 1507

Answers (2)

Mayur
Mayur

Reputation: 621

You can increase value for this org.quartz.jobStore.clusterCheckinInterval property (Default Value : 15000 milliseconds). This Property will Set the frequency (in milliseconds) at which this instance “checks-in”* with the other instances of the cluster. Affects the quickness of detecting failed instances.

You also can try with other Properties form Click here .

Upvotes: 3

Jeff
Jeff

Reputation: 61

You can use SchedulerFactoryBean to create a Scheduler with certain properties, including a datasource. See SchedulerFactoryBean.

Upvotes: 1

Related Questions