"area" appears to be a reserved word in mysql (though curiously not
listed in their reserved word list in the documentation) .. name your
table something else.
ms
On Aug 12, 2009, at 3:08 AM, Gustavo Pizano wrote:
Hello, Im posting a new thread, the replies of defining child
entities gave me a better understanding when to use inheritance.
but as yoiu follow tohe post I had problemas with the migrations..
this is the problem:
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
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
at
er
.extensions
.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:649)
at
er
.extensions
.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:613)
at
er
.extensions
.migration.ERXMigrationTable.create(ERXMigrationTable.java:797)
at
xws
.bugReporter
.migrations.BugReporterModel0.upgrade(BugReporterModel0.java:74)
at er.extensions.migration.ERXMigrationDatabase
$Migration.upgrade(ERXMigrationDatabase.java:444)
at er.extensions.migration.ERXMigrator
$ERXMigrationAction.doPerform(ERXMigrator.java:456)
at er.extensions.eof.ERXEOAccessUtilities
$ChannelAction.perform(ERXEOAccessUtilities.java:1455)
at
er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:
201)
at
er
.extensions
.appserver.ERXApplication.finishInitialization(ERXApplication.java:
1016)
... skipped 13 stack elements
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.
what can I do ?
Thanks
Gustavo
_______________________________________________
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/mschrag%40mdimension.com
This email sent to [email protected]
_______________________________________________
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]
