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.
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.
NP, good luck!