Not able to fetch JobNum,even if i have it in DB after spring and hibernate migration from version 3 to 5

[Ashwarya2617]

Currently i have update from quartz 2.3.1 to 2.3.2.....
Below is class SchedulerManagerImpl where i need JobNum value to trigger specific events,but since my jobNum is not having value its failing like below :
2025-07-28 19:50:26,411 INFO [com.eurostar.app.edcs.service.dailyeventschedule.DailyEventScheduleManagerImpl] (default task-4) SchedulerManager bean retrieved successfully: jdk.proxy40.$Proxy414
2025-07-28 19:50:26,411 DEBUG [com.eurostar.app.edcs.service.scheduler.SchedulerManagerImpl] (default task-4) About to addSchedulerEvent: null
2025-07-28 19:50:26,412 DEBUG [com.eurostar.app.edcs.service.scheduler.SchedulerManagerImpl] (default task-4) addSchedulerEvent is invoked, firingDate: Mon Jul 28 19:51:00 IST 2025, quartzData: TrainScheduleProcessingEvent, jobNum: null, operation: 0

@SuppressWarnings("deprecation")
public void addSchedulerEvent(DailyEventScheduleModel dailyEventScheduleModel,int operation)
throws EDCSServiceSystemError{
log.debug("About to addSchedulerEvent: " + dailyEventScheduleModel.getJobNumber());
Date firingDate=null;
String quartzData=null;
Long jobNum=null;
SimpleTriggerImpl simpleTrigImplObj=null;
Trigger trigger = null;
if (dailyEventScheduleModel != null){
//get manadatory details for scheduling an event in Quartz
firingDate =dailyEventScheduleModel.getFiringDate();
quartzData= dailyEventScheduleModel.getQuartzData();
jobNum=dailyEventScheduleModel.getJobNumber();
log.debug("addSchedulerEvent is invoked, firingDate: " + firingDate + ", quartzData: " + quartzData + ", jobNum: " + jobNum + ", operation: " + operation);
}
try {
if (jobNum != null && firingDate != null && quartzData != null) {
//get the Scehduler refrence.
String triggerGroup=EDCSSchedulerUtil.createTriggerGroup(dailyEventScheduleModel);
Date endTime= EDCSUtil.addDaysToDate(firingDate, 1);
Scheduler edcsScheduler =EDCSServiceLocator.getInstance().getEDCSSChedulerHandle();
// Get reference of trigger listener
SchedulerTriggerListener schedulerTriggerListener = EDCSServiceLocator
.getInstance().getEDCSSChedulerListenerHandle();
schedulerTriggerListener.setName("EDCSSchedulerTriggerListener");
if(operation==0){
// create simple trigger
simpleTrigImplObj = new SimpleTriggerImpl(jobNum.toString(),triggerGroup,quartzData,
EDCSConstants.EDCS_DEFAULT_JOB_GROUP, firingDate,
endTime, 0, 0);
// trigger.addTriggerListener(schedulerTriggerListener.getName()); //TODO : no replacement found in 2.2.1
edcsScheduler.getListenerManager().addTriggerListener(schedulerTriggerListener);
// get the trigger from SimpleTriggerImpl
trigger = simpleTrigImplObj.getTriggerBuilder().build();

            // call quartz api method to schedule a job
            edcsScheduler.scheduleJob(trigger);
            }else if(operation==1){
                //this will insert an event in quartz with paused state
                simpleTrigImplObj = new SimpleTriggerImpl(jobNum.toString(),triggerGroup);
                simpleTrigImplObj.setRepeatCount(0);
                simpleTrigImplObj.setRepeatInterval(0);
                simpleTrigImplObj.setJobName(quartzData);
                simpleTrigImplObj.setJobGroup(EDCSConstants.EDCS_DEFAULT_JOB_GROUP);
                // trigger.addTriggerListener(schedulerTriggerListener.getName()); //TODO : no replacement found in 2.2.1
                edcsScheduler.getListenerManager().addTriggerListener(schedulerTriggerListener);
                // get the trigger from SimpleTriggerImpl
                trigger = simpleTrigImplObj.getTriggerBuilder().build();
                edcsScheduler.scheduleJob(trigger);
                //pause a trigger & then set the start time
                //edcsScheduler.pauseTrigger(jobNum.toString(),triggerGroup); // commented and replaced with below line
                edcsScheduler.pauseTrigger(trigger.getKey());
                simpleTrigImplObj.setStartTime(firingDate);
                simpleTrigImplObj.setEndTime(endTime);
            }
        }
    } catch (SchedulerException e) {
    	log.error("SchedulerException occured while executing method addSchedulerEvent : " + e.getMessage());
        //log scheduler configuration exception.
		EDCSLogger.setAppSysLogModels(null, EDCSMessageConstants.TS077_10, EDCSUtil.getStackTraceString(e),
				getClass().getSimpleName(), EDCSConstants.LOG_TYPE_INTERNAL, "addSchedulerEvent", null, null, null,
				null);
        throw new EDCSServiceSystemError(EDCSConstants.ERRKEY_SYS_CONFIG,
                                         "SchedulerManagerImpl::addSchedulerEvent",
                                         "Scheduler Exception Occured");
    }
}

-------------------------Below is my quartz_properties file----------------------------------------------------------

Default Properties file for use by StdSchedulerFactory

to create a Quartz Scheduler Instance, if a different

properties file is not explicitly specified.

org.quartz.scheduler.instanceName = EDCSScheduler
org.quartz.scheduler.instanceId = AUTO

org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 20000

org.quartz.scheduler.rmi.export = false
org.quartz.scheduler.rmi.proxy = false
org.quartz.scheduler.wrapJobExecutionInUserTransaction = false
org.quartz.scheduler.userTransactionURL=java:jboss/UserTransaction

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 10
org.quartz.threadPool.threadPriority = 5
org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true

org.quartz.dataSource.myDS.driver = com.mysql.cj.jdbc.Driver
org.quartz.dataSource.myDS.URL = jdbc:mysql://localhost:3306/edcs_owner
org.quartz.dataSource.myDS.user = edcs_owner
org.quartz.dataSource.myDS.password = edcs_owner
org.quartz.dataSource.myDS.maxConnections = 5

org.quartz.jobStore.tablePrefix = qrtz_
org.quartz.jobStore.misfireThreshold = 60000
#org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreCMT
org.quartz.jobStore.useProperties = true

#org.quartz.jobStore.driverDelegateClass = com.aoi.delegate.MySQLDelegate
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.dataSource = myDS

org.quartz.plugin.shutdownhook.class = org.quartz.plugins.management.ShutdownHookPlugin
org.quartz.plugin.shutdownhook.cleanShutdown = true

#Job Initialization Plugin
org.quartz.plugin.jobInitializer.class = org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin
org.quartz.plugin.jobInitializer.fileNames = C:UsersA581781gitEDCSEDCS_SCHEDCSSCHED\resourcesquartz_jobs.xml
org.quartz.plugin.jobInitializer.failOnFileNotFound = true
org.quartz.plugin.jobInitializer.wrapInUserTransaction = true

#Trigger listener
#org.quartz.triggerListener.NAME.class = com.eurostar.app.edcs.service.scheduler.listener.SchedulerTriggerListener

---