Re: [INTERFACES] How to get oid of newly inserted row with JDBC?

You can cast the ResultSet to a org.postgresql.ResultSet and then call
getLastOID() to get the last inserted OID

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Barry Lind
Sent: Monday, January 14, 2002 1:15 PM
To: glos(at)gmx(dot)net
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] [INTERFACES] How to get oid of newly inserted row
with JDBC?

This should be posted to the pgsql-jdbc mail list. Could you provide
some more details of your problem? A test case in java would help a
lot. There isn't enough information here for me to understand your
problem.

thanks,
--Barry

glos(at)gmx(dot)net wrote:

> Hello,
>
> I inserted a serialized object in a PostgreSQL database using jdbc.
> Now I want to get back the OID of the inserted object (to store in
> other database). How do I do that, because my ResultSet gives back
> 0/zero all the time.
>
> Thanx in advance.
> G.
>
>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html