[jboss-user] [JBoss Tools (users)] - com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

[c0upal]

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