Simple issue getting started
saeediqbal1 Feb 2, 2007 5:01 PMHi 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.