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

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

    anithakothandapani

      Hi

       

      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" 
                     name="AdminWebApp.war" 
                    domain="AdminPortalDomain"
                    export-all="NON_EMPTY" 
                    import-all="false"
            parent-first="true">
      </classloading>
      

      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.