• 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: newbie needs postgresql help
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: newbie needs postgresql help


  • Subject: Re: newbie needs postgresql help
  • From: Phillip Hutchings <email@hidden>
  • Date: Tue, 22 Feb 2005 18:09:46 +1300

On 22/02/2005, at 11:12 AM, Theodore Petrosky wrote:

Not a total newbie, but to webobjects yes. I have been
developing for cocoa for about 3 years, mainly using
postgresql for my backend. I picked up a webobjects
book and I have been doing the tutorials. I finally
get enough to actually do something.

I want to access some of my tables that exist in
postgresql, but I am stumped. I just can not seem to
understand what  I need. I have the postgresql.jar
installed and I can access my database with SQL4X
Manager J. I know that java is working to talk to the
backend. I just can not seem to figure out where to
start to talk to postgresql.

Anyone with postgresql exprerience willing to help
point me in the right  direction. I have no interest
in discussing changing databases.

thanks,

Ted

I was in your boat last week ;)

You need PostresqlPlugIn and PostgresqlPlugInBundle from http://www.hexdreams.com/, compile the plugin and put it in /Library/Frameworks/ and compile the pluginbundle and put the EOMPlugin in /Developer/EOMBundles/, then in EOModeler set the plugin to PostgresqlPlugIn and the driver to org.postgresql.Driver, after that it'll work fine, right down to SQL generation.

The only bug I've found is that it puts far to may items in to the external types selection, and, not a bug but a gotcha, for primary keys you create them as int4 and then use a sequence (or webobjects creates it for you if you're using its SQL generation), and WO handles the PK creation.

--
Phillip Hutchings
email@hidden
http://www.sitharus.com/

_______________________________________________
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: newbie needs postgresql help
      • From: Theodore Petrosky <email@hidden>
References: 
 >newbie needs postgresql help (From: Theodore Petrosky <email@hidden>)

  • Prev by Date: Re: SQL log from ec.saveChanges
  • Next by Date: Fwd: wotaskd failing to start after 10.3.8 Server
  • Previous by thread: Re: newbie needs postgresql help
  • Next by thread: Re: newbie needs postgresql help
  • Index(es):
    • Date
    • Thread