On 10/31/07, Mike Schrag <email@hidden> wrote:
EM uses the classpath defined in the project the model you're editing
is in to determine how to call EOF -- Is the model's project setup
against 5.4 or 5.3?
I'm having the same problem. WOLips 5472, clean Leopard install with WO 5.4, brand new WebObjects Application project, imported the Vacation EOModel from WOnder, tried both mysql jdbc jar for
3.1.12 and 3.0.17 GA, all have the same problem:
* missing spaces when defining int types
* cannot do primary key generation
Generated SQL:
CREATE TABLE GROUPS ("groupID" intNOT NULL, "name" varchar(80)NOT NULL, "parentGroupID" int);
CREATE TABLE PERSONS ("EMAIL" varchar(255), "groupID" int, "NAME" varchar(40)NOT NULL, "notes" varchar(255), "PASSWD" varchar(20)NOT NULL, "PRIMARY_KEY" intNOT NULL, "TYPE" varchar(20)NOT NULL, "USER_ID" varchar(40)NOT NULL);
CREATE TABLE SETTINGS ("ARCHIVE_DATE" dateNOT NULL, "UNIQUE_ID" intNOT NULL);
CREATE TABLE dates ("ARCHIVED" intNOT NULL, "COMMENTARY" varchar(120), "FROM_DATE" datetimeNOT NULL, "FROM_PERIOD" varchar(2), "PERSONS_ID" intNOT NULL, "TO_DATE" datetimeNOT NULL, "TO_PERIOD" varchar(2), "TOTAL_TIME" intNOT NULL, "TYPE" varchar(80)NOT NULL, "UNIQUE_ID" intNOT NULL);
CREATE TABLE YEARLY_DATA ("PERSON_ID" intNOT NULL, "VACATION_CO" intNOT NULL, "VACATION_ENT" intNOT NULL, "YEAR" intNOT NULL);
/* The 'Create Primary Key Support' option is unavailable. */;
ALTER TABLE GROUPS ADD PRIMARY KEY (groupID);
ALTER TABLE PERSONS ADD PRIMARY KEY (PRIMARY_KEY);
ALTER TABLE SETTINGS ADD PRIMARY KEY (UNIQUE_ID);
ALTER TABLE dates ADD PRIMARY KEY (UNIQUE_ID);
ALTER TABLE YEARLY_DATA ADD PRIMARY KEY (PERSON_ID, YEAR);
ALTER TABLE GROUPS ADD CONSTRAINT GROUPS_parentGroup_FK FOREIGN KEY (parentGroupID) REFERENCES GROUPS (groupID);
ALTER TABLE PERSONS ADD CONSTRAINT PERSONS_group_FK FOREIGN KEY (groupID) REFERENCES GROUPS (groupID);
ALTER TABLE dates ADD CONSTRAINT dates_person_FK FOREIGN KEY (PERSONS_ID) REFERENCES PERSONS (PRIMARY_KEY);
ALTER TABLE YEARLY_DATA ADD CONSTRAINT YEARLY_DATA_person_FK FOREIGN KEY (PERSON_ID) REFERENCES PERSONS (PRIMARY_KEY);