Hi. I had similar errors trying to configure a clustered JBoss 4.0.5 with EJB3. I came upon this thread when trying to troubleshoot it. I don't know if this will help you or not, but in case others find this thread, in my case it turned out that I forgot to copy over and configure the mysql-jdbc2-service.xml from examples to the jms directory. So, that's one possible cause for "Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias " error you're seeing. I hope that helps. I apologize if I'm way off base. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4006027#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...