2 Replies Latest reply on Jun 11, 2010 2:49 AM by Anitha Kothandapani

    java.sql.SQLException: Invalid column name in Quartz scheduler with Jboss 5.1.0 because of version incompatibility

    Anitha Kothandapani Newbie



      I am using Jboss 5.1.0 , Open Jdk 1.6 ,My jboss-classloading.xml looks like below



      <classloading xmlns="urn:jboss:classloading:1.0" 

      So Jboss libraries will be looked at first. I want to have parent-first="true" for classcastexception issue with  xercesimpl.jar . But by doing so has an impact in quartz.jar



      While starting Quartz Scheduler. I am getting the following exception



      [   (main) [MyScheduler:startScheduler] Entering method startScheduler
      2010-04-06 14:40:50,956 ERROR [org.quartz.impl.jdbcjobstore.JobStoreTX]   (main) ClusterManager: Error managing cluster: Failure identifying failed   instances when checking-in: Invalid column name
      org.quartz.JobPersistenceException: Failure identifying failed instances   when checking-in: Invalid column name [See nested exception:   java.sql.SQLException: Invalid column name]
        at   org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:2100)


      This issue is occuring since jboss 5.1 is having the quartz.jar (1.5.2) which is of lesser version than in my WAR (quartz-all 1.6.4)


      As a workaround I replaced the quartz.jar of Jboss to quart-all1.6.4 which is not ideal.


      Please help me to get a proper solution for this.