[jboss-user] [JBoss Seam] - MySQL SQL Syntax Problem Using Generated Reverse Eng. Code

... originally posted in the wrong place Using: jboss-4.0.4.GA jboss-seam-1.0.1.GA eclipse 3.2.0 jboss reverse engineer tool in eclipse I geneated, compiled and successfully deployed my sean app to JBoss. I added a record successfully to one of the tables. When I went to search for a record, I get this: 11:31:06,578 INFO [STDOUT] Hibernate: select top ? room0_.ID as ID10_, room0_.Name as Name10_, room0_.OrganizationID as Organiza3 _10_, room0_.Capacity as Capacity10_ from checkin.room room0_ 11:31:06,625 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000 11:31:06,625 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL s erver version for the right syntax to use near '1 room0_.ID as ID10_, room0_.Name as Name10_, room0_.OrganizationID as Organiza3' at line 1 11:31:06,625 ERROR [SeamExceptionFilter] uncaught exception handled by Seam javax.servlet.ServletException: Error calling action method of component with id _id2:_id27 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) This is bad SQL. Is this a bug. I haven't touched the generated code. Thanks. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3973714#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...