Quartz problem, Couldn't create delegate

Ranch Hand

Posts: 119

posted 6 months ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

we have a J2EE application using spring/hibernate. We also use Quartz scheduler.
We have these dependencies in pom.xml
quartz 2.3.0 and quartz-oracle 2.1.7
We have many istallations deployed on Tomcat 8 both on Windows and Linux.
Now we encountered problem on one Linux. Something with Quartz.

this i get by using StdScheduler (getJobGroupNames(), getJobKeys(...)

and this trying to write cron settings via quartz api

Exception in thread "Quartz Scheduler [W4Scheduler]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; 
nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.NoSuchDelegateException: 
Couldn't create delegate: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate [See nested exception: java.lang.InstantiationException: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate]]
	at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:671)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.NoSuchDelegateException: 
Couldn't create delegate: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate [See nested exception: java.lang.InstantiationException: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate]]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:697)
	at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:539)
	at org.quartz.impl.StdScheduler.start(StdScheduler.java:142)
	at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:668)
Caused by: org.quartz.impl.jdbcjobstore.NoSuchDelegateException: Couldn't create delegate: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate 
[See nested exception: java.lang.InstantiationException: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getDelegate(JobStoreSupport.java:3218)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:860)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:843)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3780)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3778)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:839)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:695)
	... 3 more
Caused by: java.lang.InstantiationException: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
	at java.lang.Class.newInstance(Class.java:427)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getDelegate(JobStoreSupport.java:3213)
	... 10 more
Caused by: java.lang.NoSuchMethodException: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.<init>()
	at java.lang.Class.getConstructor0(Class.java:3082)
	at java.lang.Class.newInstance(Class.java:412)
	... 11 more

I think there's some communication problem between quartz library and its tables such as QRTZ_JOB_DETAILS and QRTZ_TRIGGERS. Both reading and writing.
The problem with StdScheduler (getJobGroupNames(), getJobKeys(...)) I overcame by direct access via hibernate using plain sql.
It worked, but writng cron settings via quartz api led to above error. I am at the end, I cannot rewrite whole quartz api logic.

My environment settings
The server is Debian GNU/Linux 12 (bookworm)
Apache Tomcat/8.0.14
JDBC lib is ojdbc8.jar (in Tomcat's lib folder]
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

Any ideas what can be wrong ? Thanks.

Don't get me started about those stupid light bulbs.