Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)

hi everyone,
i am badly in need of your help in implementing the quartz scheduler.
i am having oracle DB and i am using hibernate also.

i am getting this exception when i start the server. i am going with 1.5.2 version of quartz.

[Server:server-one] 06:41:45,690 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/ScheduleViewer]] (MSC service thread 1-9) StandardWrapper.Throwable: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BSTrigger' defined in class path resource [config/NewsspTimerCotxt.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerException: Registration of jobs and triggers failed: oracle/sql/BLOB
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at com.amber.ist.retail.scheduleviewer.servlet.timer.TimerStoreLocatorServlet.init(TimerStoreLocatorServlet.java:29) [classes:]
[Server:server-one]  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
[Server:server-one]  at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
[Server:server-one]  at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
[Server:server-one]  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_29]
[Server:server-one]  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_29]
[Server:server-one]  at java.lang.Thread.run(Thread.java:662) [:1.6.0_29]
[Server:server-one] Caused by: org.quartz.SchedulerException: Registration of jobs and triggers failed: oracle/sql/BLOB
[Server:server-one]  at org.springframework.scheduling.quartz.SchedulerAccessor.registerJobsAndTriggers(SchedulerAccessor.java:298) [spring-context-support-2.5.6.jar:]
[Server:server-one]  at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:483) [spring-context-support-2.5.6.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  ... 22 more
[Server:server-one]
[Server:server-one] 06:41:45,703 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/ScheduleViewer]] (MSC service thread 1-9) Servlet /ScheduleViewer threw load() exception: org.quartz.SchedulerException: Registration of jobs and triggers failed: oracle/sql/BLOB
[Server:server-one]  at org.springframework.scheduling.quartz.SchedulerAccessor.registerJobsAndTriggers(SchedulerAccessor.java:298) [spring-context-support-2.5.6.jar:]
[Server:server-one]  at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:483) [spring-context-support-2.5.6.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567) [org.springframework.beans-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) [org.springframework.context-3.0.6.RELEASE.jar:]
[Server:server-one]  at com.amberl.ist.retail.scheduleviewer.servlet.timer.TimerStoreLocatorServlet.init(TimerStoreLocatorServlet.java:29) [classes:]
[Server:server-one]  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
[Server:server-one]  at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
[Server:server-one]  at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
[Server:server-one]  at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
[Server:server-one]  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_29]
[Server:server-one]  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_29]
[Server:server-one]  at java.lang.Thread.run(Thread.java:662) [:1.6.0_29]
[Server:server-one]

also the properties

<bean id ="BSTrigger"
  class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
  <property name="triggers">
   <list>
    <ref bean="cacheCleanupTrigger" />
   </list>
  </property>
  <property name="dataSource">
   <ref bean="dataSource"/>
  </property>

  <property name="quartzProperties">
   <props>
     <prop key="org.quartz.scheduler.instanceName">MyClusteredScheduler</prop>
      <prop key="org.quartz.scheduler.instanceId ">AUTO</prop>
    <prop key="org.quartz.jobStore.class">org.quartz.impl.jdbcjobstore.JobStoreTX</prop>
    <prop key="org.quartz.jobStore.driverDelegateClass">org.quartz.impl.jdbcjobstore.oracle.OracleDelegate</prop>
    <prop key="org.quartz.jobStore.tablePrefix"> QRTZ_</prop>
    <prop key="org.quartz.jobStore.misfireThreshold">60000</prop>
    <prop key="org.quartz.jobStore.isClustered">true</prop>
    <prop key="org.quartz.threadPool.class">org.quartz.simpl.SimpleThreadPool</prop>
    <prop key="org.quartz.threadPool.threadCount">10</prop>
    <prop key="org.quartz.threadPool.threadPriority"> 5</prop>
    <prop key="org.quartz.jobStore.useProperties">false</prop>
    <prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?</prop>
</props>
</property>
</bean>

you are using very old version of quartz. I would suggest you to try out with latest version of quartz which is 2.1.5.
and let us know if issue still persist.

Cheers!!

Upgrading from 1.5.2 to 2.1.5 is a big leap in terms of code changes as are there are enough Quartz API changes. I would suggest trying to upgrade to 1.8.6 which seems to be the last release on this API to see if that helps

- Santhi

Hi,
This error still exist in latest quartz-2.2.0 distro. Any updates?

There is not enough info above to tell what the actual problem is. Is there any more logging? Any more further "caused by" exception?