0 Replies Latest reply on Feb 2, 2007 5:01 PM by Saeed Iqbal

    Simple issue getting started

    Saeed Iqbal Novice

      Hi Guys,

      I am not very familiar with jboss/seam/hibernate. So therefore I would like some help getting started.

      First i got the createTablesOnStartup error that i changed to false.

      Now here are the errors that i'm getting

      2007-02-02 13:51:17,359 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing SQL: select HIGHVALUES from HILOSEQUENCES where SEQUENCENAME='general'
      2007-02-02 13:51:17,375 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Started jboss:service=KeyGeneratorFactory,type=HiLo
      2007-02-02 13:51:17,375 DEBUG [org.jboss.ejb3.timerservice.quartz.jmx.EJB3TimerService] Starting jboss.ejb:service=EJB3TimerService
      2007-02-02 13:51:17,390 DEBUG [org.jboss.ejb3.timerservice.quartz.QuartzTimerServiceFactory] properties = {org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread=true, org.quartz.jobStore.dataSource=myDS, org.quartz.scheduler.rmi.proxy=false, org.quartz.scheduler.rmi.export=false, org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.HSQLDBDelegate, org.quartz.jobStore.misfireThreshold=60000, org.quartz.jobStore.selectWithLockSQL=SELECT * FROM qrtz_locks WHERE lock_name = ?, org.quartz.threadPool.threadCount=10, org.quartz.jobStore.nonManagedTXDataSource=myDS, org.quartz.scheduler.instanceName=JBossEJB3QuartzScheduler, org.quartz.scheduler.wrapJobExecutionInUserTransaction=false, org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool, org.quartz.jobStore.tablePrefix=QRTZ_, org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreCMT, org.quartz.threadPool.threadPriority=5}
      2007-02-02 13:51:17,453 WARN [org.jboss.ejb3.timerservice.quartz.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 VARCHAR(1) NOT NULL, REQUESTS_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BINARY NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP))
      2007-02-02 13:51:17,468 DEBUG [org.jboss.ejb3.timerservice.quartz.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 VARCHAR(1) NOT NULL, REQUESTS_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BINARY NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP))
      java.sql.SQLException: Table already exists: QRTZ_JOB_DETAILS in statement [CREATE TABLE qrtz_job_details]
      at org.hsqldb.jdbc.Util.throwError(Unknown Source)




      and

      2007-02-02 13:51:17,687 WARN [org.jboss.messaging.core.plugin.JDBCPersistenceManager]

      JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently NONE.
      Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
      Using an isolation level more strict than READ_COMMITTED may lead to deadlock.

      2007-02-02 13:51:17,703 DEBUG [org.jboss.messaging.core.plugin.JDBCPersistenceManager] JDBCPersistenceManager[154ec5] started



      and

      007-02-02 13:51:19,093 DEBUG [org.jboss.web.tomcat.tc6.deployers.TomcatDeployment] Using session cookies default setting
      2007-02-02 13:51:19,109 DEBUG [org.jboss.web.tomcat.tc6.WebAppLoader] injectionContainer enabled and processing beginning with Tomcat WebAppLoader
      2007-02-02 13:51:19,156 ERROR [org.apache.tomcat.util.modeler.BaseModelMBean] Exception invoking method addChild
      java.lang.RuntimeException: could not find listener class in classpath
      at org.jboss.web.tomcat.tc6.TomcatInjectionContainer.processMetadata(TomcatInjectionContainer.java:339)



      ...
      ...

      Caused by: java.lang.ClassNotFoundException: org.apache.myfaces.webapp.StartupServletContextListener
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355)
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
      at org.jboss.web.tomcat.tc6.TomcatInjectionContainer.processMetadata(TomcatInjectionContainer.java:333)
      ... 65 more
      20





      I am pretty sure somewhat that its classpath related error because the same setup works at my other computer at work. doesn't work at home. I do most development at work ofcourse.