EOF and PostgreSQL Serial primary keys
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