On Aug 12, 2009, at 3:08 AM, Gustavo Pizano wrote:

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 'Area(descr VARCHAR(255) NOT NULL, id INTEGER NOT NULL, name VARCHAR(16) NOT NULL' at line 1

when trying to ccreate the table Area, which entity has a relationship to itself as Area< - >> Area with areaID as the FK. I remove that relationship and still Im havin the same error.

Hey Gustavo,

Can you turn on the EOAdapter Debugging so we can see the exact SQL that is being passed to the DB? (You can find it in the Run Configuration WO tab. Set -EOAdapterDebugEnabled to true.

It looks like there is something wrong with the SQL that is getting generated, but it's hard to tell with just the fragment in the exception.

Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to