My development enviroment is on Windows / MySql5 / JDK5, I am setting up my prod enviroment on RHEL3 /MySql5/JDK5. I have configured (in both envorments) all of the Persistence and caching using MySQL. This works fine in my development enviroment. However on Linux everytime I restart I get the following errors unless I clean the DB first.
20:04:50,579 WARN [ServiceController] Problem starting service jboss:service=KeyGeneratorFactory,type=HiLo
java.sql.SQLException: Table 'HILOSEQUENCES' already exists
... (truncated)
--- MBeans waiting for other MBeans ---
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
--- 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
Any suggestions?
Solved by upgrading to: mysql-connector-java-3.1.12 from 3.1.11