On 15-Apr-08, at 2:09 PM, J Stephanos wrote:
When I use Mike's WO53 -> WO54 script (See http://lists.apple.com/archives/Webobjects-dev/2007/Oct/msg00357.html) to switch between 5.3 and 5.4, here are the differences seen in Entity Modeler when used to Generate SQL: MySQL 5.0.51a Eclipse 3.3.1.1 WOLips 5085 with WO 5.3 ------------------- CREATE TABLE Address ( address1 varchar(40), address2 varchar(40), city varchar(30), zip char(10), identifier bigint NOT NULL, retailStoreID bigint NOT NULL, state varchar(30) ); ALTER TABLE Address ADD PRIMARY KEY (identifier); with WO 5.4 ------------------- CREATE TABLE Address ("address1" varchar(40), "address2" varchar(40), "city" varchar(30), "zip" varchar(10), "identifier" bigint NOT NULL, "retailStoreID" bigint NOT NULL, "state" varchar(30) ); ALTER TABLE Address ADD PRIMARY KEY (identifier); ALTER TABLE Address ADD CONSTRAINT Address_retailStore_FK FOREIGN KEY (retailStoreID) REFERENCES RetailStore (identifier); 5.4 adds quotes - fails to create the table in MySQL. Adds all the FK constraints. 5.3 does not generate FK constraint. Is there a workaround to generate sql correctly with 5.4.
There are known issues with SQL generation in 5.4 - they are apparently resolved in the next release from Apple.
So, workaround 1: Wait for WO 5.4.next
Of course, I could generate with 5.4 and remove quotes - is this advisable?
Workaround 2: This, or manually generate your SQL. ;david -- David LeBer Codeferous Software 'co-def-er-ous' adj. Literally 'code-bearing' site: http://codeferous.com blog: http://davidleber.net profile: http://www.linkedin.com/in/davidleber -- Toronto Area Cocoa / WebObjects developers group: http://tacow.org
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
