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

[johnurban]

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

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3973714