1 Reply Latest reply on Jun 13, 2008 9:11 AM by Max Rydahl Andersen

    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

    Anthony Yulo Newbie

      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?