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/archive%40mail-archive.com This email sent to [email protected]
