org.quartz.JobPersistenceException: Couldn't store trigger 'T_QRTZ.TraitBdd_Trigger' for 'QRTZ.TraitBdd' job:Unknown column 'TRIGGER_TYPE' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'TRIGGER_TYPE' in 'field list']

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via terracotta.org by Unknown author, 2 years ago
Couldn't store trigger 'T_QRTZ.TraitBdd_Trigger' for 'QRTZ.TraitBdd' job:Unknown column 'TRIGGER_TYPE' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'TRIGGER_TYPE' in 'field list']
via Terracotta by Jeh, 1 year ago
Couldn't store trigger 'T_QRTZ.TraitBdd_Trigger' for 'QRTZ.TraitBdd' job:Unknown column 'TRIGGER_TYPE' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'TRIGGER_TYPE' in 'field list']
via Stack Overflow by boycod3
, 1 year ago
Couldn't store trigger 'job1' for 'sampleJobRunner' job:The job (sampleGroup.sampleJobRunner) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (sampleGroup.sampleJobRunner) referenced by the trigger does not exist.]
via Terracotta by amolfuke, 1 year ago
Couldn't store trigger: The job (DEFAULT.JobTrigger_2425) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (DEFAULT.JobTrigger_2425) referenced by the trigger does not exist.]
via GitHub by wszyquan
, 2 years ago
Couldn't store trigger 'DEFAULT.timerTrigger' for 'DEFAULT.timerJobDetail' job:The job (DEFAULT.timerJobDetail) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (DEFAULT.timerJobDetail) referenced by the trigger does not exist.]
via Stack Overflow by Tomas Bartalos
, 1 year ago
Couldn't store trigger 'RebillJobSimpleTrigger' for 'com.payment.rebill.RebillJob' job:Bad value for type long : \xaced00057.....
org.quartz.JobPersistenceException: Couldn't store trigger 'T_QRTZ.TraitBdd_Trigger' for 'QRTZ.TraitBdd' job:Unknown column 'TRIGGER_TYPE' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'TRIGGER_TYPE' in 'field list']
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.execute(JobStoreSupport.java:1007)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$45.execute(JobStoreSupport.java:3654)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3726)
at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3650)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1002)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:816)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:250)
at org.quartz.xml.XMLSchedulingDataProcessor.scheduleJobs(XMLSchedulingDataProcessor.java:1119)
at org.quartz.xml.XMLSchedulingDataProcessor.processFileAndScheduleJobs(XMLSchedulingDataProcessor.java:892)
at org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin.processFile(XMLSchedulingDataProcessorPlugin.java:327)
at org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin.start(XMLSchedulingDataProcessorPlugin.java:255)
at org.quartz.plugins.SchedulerPluginWithUserTransactionSupport.start(SchedulerPluginWithUserTransactionSupport.java:144)
at org.quartz.core.QuartzScheduler.startPlugins(QuartzScheduler.java:2292)
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:508)
at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.