[jboss-user] [Installation, Configuration & Deployment] - Re: Setting DefaultDS to use Postgresql in JBoss AS 5.0.0 Be

[fatbatman]

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