I am having trouble running my First Jboss Seam application. When I run a seam-generated page that queries a MySql Database:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias When I traced the problem the SQL statement generated was "Select * from (Select emp_id from Eployees employee1)" I think the subquery must have its own alias which seam did not provide. The SQL statement should be something like this: "Select * from (Select emp_id from Eployees employee1) as empployee2" How do you work around this? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4157929#4157929 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4157929 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
