Thanks for your response, sorry I should have been more specific in my initial question. I'd done what you suggested above but I'm getting problems. These seem to stem from the fact that "qrtz_locks" table does not exist.
| ............ | 21:46:03,515 INFO [RARDeployment] Required license terms exist, view vfsfile:/D:/workspace/jboss-5.0.0.Beta2/server/default/deploy/jboss-local-jdbc.r | ar/META-INF/ra.xml | 21:46:03,750 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultD | S' | 21:46:06,218 WARN [QuartzTimerServiceFactory] sql failed: CREATE TABLE qrtz_job_details(JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL | , DESCRIPTION VARCHAR(120) NULL, JOB_CLASS_NAME VARCHAR(128) NOT NULL, IS_DURABLE VARCHAR(1) NOT NULL, IS_VOLATILE VARCHAR(1) NOT NULL, IS_STATEFUL VA | RCHAR(1) NOT NULL, REQUESTS_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BINARY NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP)) | 21:46:06,656 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main | 21:46:06,750 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created. | 21:46:06,750 INFO [JobStoreCMT] Using db table-based data access locking (synchronization). | 21:46:06,781 ERROR [AbstractKernelController] Error installing to Start: name=jboss.ejb:service=EJB3TimerService state=Create mode=Manual requiredStat | e=Installed | org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure o | btaining db row lock: ERROR: relation "qrtz_locks" does not exist [See nested exception: org.postgresql.util.PSQLException: ERROR: relation "qrtz_lock | s" does not exist]] | at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) | at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) | at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) | at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) | at org.jboss.ejb3.timerservice.quartz.QuartzTimerServiceFactory.start(QuartzTimerServiceFactory.java:257) | at org.jboss.ejb3.timerservice.quartz.jmx.EJB3TimerService.startService(EJB3TimerService.java:105) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) | at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) | at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) | ........... | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049537#4049537 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4049537 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
