Issues with seam generate-entities and mysql

agwego Mar 5, 2007 12:59 AM

I'm using jboss-seam-1.2.0.PATCH1, jboss-4.0.5.GA, mysql-connector-java-5.0.5, Mysql 5.0.27-community-nt
I'm a noob wrt to Seam.

The code appears to be generated fine, but when accessing the tables form the generated app a '.' dot is being prepended to all the table names which of course fails.

For the edit form:

Exception during request processing: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.users (Valid, Passwo...

For the list page:

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.users users0_ limit 25' at line 1

1. Re: Issues with seam generate-entities and mysql

agwego Mar 5, 2007 2:00 AM (in response to agwego)

I hate answering my own questions:

The problem was with seam setup and confusion between catalog/schema and the connection string.

It's unfortunate the stack trace truncated both the errors at '.users' further sifting of the log revealed the queries were being constucted like '... from cat.cat.users' where the catlog was being repeated twice due to my confusion between the purpose of catalog/schema and the connection string.
Actions