Using MySQL for DefaultDS

[radix_zero]

Using 4.0.3 w/ MySQL 5.

I am trying to configure JBoss to use MySQL for is data store. I am getting a

java.sql.SQLException: Table 'TIMERS' already exists
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

when after the first start up. It seems to successfully create the tables the first time then get upset that the table still exist on the next start up.

Not sure where to start to fix this.

thanks

[payet.b]

It's working with me (MySQL 4.0).
Can you post more details to see which module is generating this error.
It might come from GeneralPurposeDatabasePersistencePlugin...

[swarne111]

Try this:

http://www.techienuggets.com/Detail?tx=5