0 Replies Latest reply on Feb 22, 2005 12:51 PM by bobsmith

    Exception during start up regarding table creation

    bobsmith

      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?

      Thanks,
      Bob