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: 

anonymous wrote : 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

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3901663#3901663

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3901663


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to