Re: newbie needs postgresql help
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