• 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: EOF and PostgreSQL Serial primary keys
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOF and PostgreSQL Serial primary keys


  • Subject: Re: EOF and PostgreSQL Serial primary keys
  • From: Geoff Hopson <email@hidden>
  • Date: Thu, 17 Feb 2005 16:37:48 +0000

I use a simple int4 to hold the PK, and create a sequence called <entity>_seq (one per entity - eg customer_seq)

ALso make sure that you link in (is that the right word these days) the POstgresPlugin framework into your app.

I've not used the Wonder frameworks yet - Kenny's Hexdreams ones work just dandy for me.

Good luck.

Geoff


Arturo Perez wrote:
Phillip Hutchings wrote:

Hi,

I'm new at WebObjects, so I apologise if this is an RTFM-type question.

I've managed to get WebObjects working with postgres using the framework from hexdreams.com.


You may want to look at the drivers from Project Wonder, they're lots better.

IIRC, you can't use a SERIAL datatype with WebObjects for any database. None of the database drivers return, without some effort, the generated primary key when one uses the SERIAL datatype. There are various options for having WO generate primary keys: using a SEQUENCE, internally generated by EOF (24bytes), etc.

-arturo
_______________________________________________
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

_______________________________________________
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


References: 
 >EOF and PostgreSQL Serial primary keys (From: Phillip Hutchings <email@hidden>)
 >Re: EOF and PostgreSQL Serial primary keys (From: Arturo Perez <email@hidden>)

  • Prev by Date: Page form or SubComponent form Design Pattern?
  • Next by Date: Streaming HTTP Connection?
  • Previous by thread: Re: EOF and PostgreSQL Serial primary keys
  • Next by thread: Binding EOF Fecth Qualifier in IB
  • Index(es):
    • Date
    • Thread