I don't see that and we use MySQL. Is your adaptor URl something like this:

jdbc:mysql://localhost/MyDB? capitalizeTypeNames=true&zeroDateTimeBehavior=convertToNull

With driver set to com.mysql.jdbc.Driver ?

And the Mysql driver (5.1.?) in /Library/Java/Extensions ?

Simon

On 18 Dec 2007, at 18:21, James Nugent wrote:

Is the EOModeller Eclipse Plugin's SQL generation problems related to WO5.4?

Which SQL generation problem? The "no space before the 'not null' constraint" problem? Yes, this is a Leopard problem. At least the FrontBase and the PostgreSQL plugins from Wonder work around it. Or what other problems do you see?

I'm using MySQL 5.0.45 with the latest version of the JDBC connector installed in my /Library/Java/Extensions directory.

Having created a simple model similar to the one used in Wolf Rentzsch's "WO5 in 15 minutes" video, and clicking the Generate SQL button, I get the following code generated:

CREATE TABLE T_BLOGENTRY ("C_ENTRYBODY" BLOB NOT NULL, "C_ENTRYPK" INT NOT NULL, "C_ENTRYTITLE" VARCHAR(255)NOT NULL);

/* The 'Create Primary Key Support' option is unavailable. */;

ALTER TABLE T_BLOGENTRY ADD PRIMARY KEY (C_ENTRYPK);

Is this a known problem with using MySQL, or is it likely I just have something configured wrong?

Cheers,


James
_______________________________________________
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/simon_mclean% 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]

Reply via email to