I received "Table Not Found Exception" while using JBoss RC3 with MySql. To the best of my knowledge, mysql-service.xml, login-config.xml, standardjbosscmp-jdbc.xml,
application.xml, ejb-jar.xml and jboss.xml were properly configured to reflect my operating environment. Lookup and the creation of the home object was successful, it got a connection from the datasource but failed while trying to execute the following command: pstmt = conn.prepareStatement("select sum(balance) as total from accounts");

Any suggestions as to the cause of the exception and how to solve the problem.