org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause']]

Terracotta | naveenj | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re:Database scripts

    Terracotta | 5 years ago | naveenj
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause']]
  2. 0

    Spring 4.3.0.RELEASE + Hibernate 5.2.0.Final - GeneratedValue on mysql

    Stack Overflow | 9 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  3. 0

    java error with api/person

    GitHub | 4 years ago | jluc2808
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Running my application with Spring, Hibernate, Tomcat, and MySQL Community Server

    Stack Overflow | 6 years ago | estur
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'project.products' doesn't exist
  6. 0

    Update SonarQube 3.7 to 4.5.1 error [o.s.s.ui.JRubyFacade] Fail to upgrade database

    Stack Overflow | 2 years ago | fimbresrc
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm.measure_data' in 'on clause'** ...

  1. MrMonkey 2 times, last 12 months ago
  2. osvzs 1 times, last 3 days ago
  3. Kialandei 1 times, last 4 months ago
  4. davidvanlaatum 8 times, last 6 months ago
  5. AndrewProg 2 times, last 6 months ago
25 more registered users
70 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown column 'IS_VOLATILE' in 'where clause'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    2. com.mysql.jdbc.Util.getInstance(Util.java:384)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
    10 frames
  4. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
    1 frame
  5. quartz
    StdSchedulerFactory.getScheduler
    1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectVolatileTriggers(StdJDBCDelegate.java:3494)
    2. org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:767)
    3. org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:750)
    4. org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3726)
    5. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3760)
    6. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3722)
    7. org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:746)
    8. org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:604)
    9. org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:59)
    10. org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1225)
    11. org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1376)
    11 frames
  6. com.hs18.schedular
    TestClass.main
    1. com.hs18.schedular.TestClass.start(TestClass.java:30)
    2. com.hs18.schedular.TestClass.main(TestClass.java:59)
    2 frames