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.

[gavin.king]

This is bad SQL. Is this a bug. I haven't touched the generated code.

You are trying to use the dialect for HSQLDB with MySQL.

No offense meant, but in future, please take some time to read documentation before accusing us of bugs, thanks.

[johnurban]

Thank for the quick reply! I did indeed have the wrong dialect in my persistance.xml.

[gavin king] In future, please take some time to read documentation before accusing us of bugs..

[john] Point well taken. I did want to compliment you guys on your docs. I followed the JBoss Seam getting started and it worked flawlessly. I'll push myself a little further next time in the reading.

[gavin.king]

NP, good luck!