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@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Barry Lind
Sent: Monday, January 14, 2002 1:15 PM
To: glos@gmx.net
Cc: pgsql-jdbc@postgresql.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@gmx.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
