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

EOF and PostgreSQL Serial primary keys


  • Subject: EOF and PostgreSQL Serial primary keys
  • From: Phillip Hutchings <email@hidden>
  • Date: Thu, 17 Feb 2005 21:35:34 +1300

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. It works fine for selecting, but I can't insert. I'm using postgresql 8 and the serial datatype for primary keys, which should generate a new ID automatically.

However, when I insert a new item I get this error: java.lang.IllegalStateException: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@a0df30 failed to provide new primary keys for entity 'AccountTransaction'

Which leads me to believe that the postgres driver doesn't return the new sequence number on an insert, so I'm wondering if I need to make an alternative primary key, or somehow let WebObjects handle the key creation. I have the feeling I'm missing something important here.

Any help/clues/pointers?
--
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: EOF and PostgreSQL Serial primary keys
      • From: Arturo Perez <email@hidden>
  • Prev by Date: Re: attempt to assign value to unknown key
  • Next by Date: Binding EOF Fecth Qualifier in IB
  • Previous by thread: Re: attempt to assign value to unknown key
  • Next by thread: Re: EOF and PostgreSQL Serial primary keys
  • Index(es):
    • Date
    • Thread