3 Replies Latest reply on Sep 23, 2006 1:47 PM by Gavin King

    MySQL SQL Syntax Problem Using Generated Reverse Eng. Code

    johnurban Newbie

      ... 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.