FWIW, try the 5.0.XX driver (which is what I use for dev and
production with 4.1.XX MySQL.)
On Oct 31, 2007, at 9:26 AM, RedBugz Software wrote:
On 10/31/07, Mike Schrag <[EMAIL PROTECTED]> 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);
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%
40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
