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?
ask in jboss seam forum - the question is not tool specific.