EOModeler "Synchronize Schema" command
EOModeler "Synchronize Schema" command
- Subject: EOModeler "Synchronize Schema" command
- From: Tom Woteki <email@hidden>
- Date: Sat, 2 Oct 2004 16:46:56 -0400
The Synchronize Schema command in EOModeler seems not to work properly. Let's say I create a simple database, foobar, with one table, FOO, that has one attribute that is its primary key. Then I create the table using the generate SQL option which also creates the eo_pk_table.
Immediately thereafter I invoke "synchronize schema". This is the SQL that is generated by EOModeler:
drop table EO_PK_TABLE CASCADE
alter table FOO drop primary key
rename table FOO to EO_OLD_FOO
CREATE table FOO (ID INT NOT NULL)
drop table EO_OLD_FOO CASCADE
CREATE table EO_PK_TABLE (NAME CHAR(40) primary KEY, PK INT)
alter table FOO add primary key (ID)
Why does it want to do any synchronization? Nothing changed since the table was created.
If I go ahead and perform the synchronization and then immediately perform it again, I get the same SQL and so on ad infinitum.
I am using mysql "Ver 12.22 Distrib 4.0.18, for apple-darwin7.0" as installed on OSX Server with the jdbc driver "
mysql-connector-java-3.0.15-ga-bin.jar" The WO version is 5.2.3.
Thanks for any help.
Tom _______________________________________________
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