• 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: WO and MySQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: WO and MySQL


  • Subject: Re: WO and MySQL
  • From: LD <email@hidden>
  • Date: Mon, 17 Oct 2005 13:44:02 +1000

Hi Colin

On 17/10/2005, at 3:25 AM, Colin Shreffler wrote:

I’m working on my first WO project. I’ve been trying to get it to work with
PostgreSQL for some time because I believe it to be a great RDBMS, but
continue to have problems. One step forward, one step back, etc. I’ve
tried to use Project Wonder to solve these issues, but continue to have
problems... I’m getting fed up!

As Anjo mentioned, it'd be good to know exactly what problems you're having.


I'm using PostgreSQL without any problems.

The trick to getting it working all boils down to the plugin. You'll want to install the PostgresqlPlugIn.EOMplugin and the PostgresqlPlugIn.framework and the correct locations (/Developer/ EOMBunles, Library/Frameworks respectively) and make sure to reference the framework in your project.

The one thing to be aware of when using the current version of the Project Wonder (and even the HexDreams version) of the PostgresqlPlugIns is that if you decide to use the "serial" column type for your primary keys (i.e., selecting these in EOModeler for a column) then the plugin won't find the correct column [1].

There's an easy fix for this (by editing the source code for the plugin). Otherwise, simply use an int type, choose to create primary key support when generating SQL from EOModeler and you should be right.


Let me know if you need more help with this...

[1] The postgres serial type automatically creates a sequenced called: <tableName>_<pkColumn>_SEQ whereas the current version of the plugin looks for a sequence called <tableName>_SEQ.

with regards,
--

LD


_______________________________________________ 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: WO and MySQL
      • From: Johan Henselmans <email@hidden>
References: 
 >WO and MySQL (From: Colin Shreffler <email@hidden>)

  • Prev by Date: Re: PosgreSQL & NSTimestamp
  • Next by Date: Re: Calling WOResourceManager from Session
  • Previous by thread: Re: WO and MySQL
  • Next by thread: Re: WO and MySQL
  • Index(es):
    • Date
    • Thread