Migration failed, was : defining child entities
Migration failed, was : defining child entities
- Subject: Migration failed, was : defining child entities
- From: Gustavo Pizano <email@hidden>
- Date: Wed, 12 Aug 2009 09:08:27 +0200
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