Thread: getGeneratedKeys()

getGeneratedKeys()

From
Jamie Deppeler
Date:
Hi to all,

I have one problem with PostgreSQL and Java. I have a table with Primary
key(serial) field, but after I insert a record i am unable to retrieve
this value.  I have tried getGeneratedKeys() and i get nothing returned.

There is another method to retrieve this field?

thanks


Re: getGeneratedKeys()

From
"Joshua D. Drake"
Date:
On Fri, 2005-04-01 at 10:05 +1000, Jamie Deppeler wrote:
> Hi to all,
>
> I have one problem with PostgreSQL and Java. I have a table with Primary
> key(serial) field, but after I insert a record i am unable to retrieve
> this value.  I have tried getGeneratedKeys() and i get nothing returned.

I am not a Java programmer but normally I would use select currval
('sequencename');


>
> There is another method to retrieve this field?
>
> thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/