Re: Migration failed, was : defining child entities
Re: Migration failed, was : defining child entities
- Subject: Re: Migration failed, was : defining child entities
- From: Mike Schrag <email@hidden>
- Date: Wed, 12 Aug 2009 08:28:23 -0400
"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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden