I am using JBoss 3.2.6 and MySQL version 4.0.20 on Windows XP.
I'm getting the following error when starting JBoss:
2005-02-22 04:02:15,000 ERROR [org.jboss.ejb.EntityContainer] Starting failed jboss.j2ee:jndiName=ejb/T1Bean,service=EJB
org.jboss.deployment.DeploymentException: Error while creating table stTable; - nested throwable: (java.sql.SQLException: General error message from server: "Table 'sttable' already exists")
The problem appears to be that the org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(-) method [in jboss.jar] says that the table doesn't exist (although it does), and therefore an attempt is made to create the table, which fails with the above exception because the table already exists.
Does anyone have any pointers as what could be the problem?