2 Replies Latest reply on Oct 25, 2005 3:26 PM by shreyas_s_shah

    JBoss 4.0.3 + mySQL and TIMERS and HILOSEQUENCES

      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