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#4006027 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4006027 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
