I changed the database to mySQL and removed all references to the Hypersonic database. But now I get an error with the EJBTimerService and KeyGeneratorFactory starting up.
If the tables TIMERS and HILOSEQUENCES exists I get the following report:
2005-10-16 18:21:33,910 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: java.sql.SQLException: Table 'TIMERS' already exists
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: java.sql.SQLException: Table 'TIMERS' already exists
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
If I drop the tables the server starts up just fine. Is there a config setting that allows dropping of those tables on shutdown?...or is there a way it will not error out when the tables exists and just use the?
Any help is appreciated.
-tc