• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: A REAL newbie
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: A REAL newbie


  • Subject: Re: A REAL newbie
  • From: Simon McLean <email@hidden>
  • Date: Tue, 18 Dec 2007 18:25:18 +0000

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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com


This email sent to email@hidden

_______________________________________________ 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
  • Follow-Ups:
    • Re: A REAL newbie
      • From: James Nugent <email@hidden>
References: 
 >A REAL newbie (From: Doug Thompson <email@hidden>)
 >Re: A REAL newbie (From: Pascal Robert <email@hidden>)
 >Re: A REAL newbie (From: James Nugent <email@hidden>)
 >Re: A REAL newbie (From: Guido Neitzer <email@hidden>)
 >Re: A REAL newbie (From: James Nugent <email@hidden>)

  • Prev by Date: Re: direct action security question...
  • Next by Date: Re: A REAL newbie
  • Previous by thread: Re: A REAL newbie
  • Next by thread: Re: A REAL newbie
  • Index(es):
    • Date
    • Thread