Re: JDBC and fetching the OID of an insert - Mailing list pgsql-jdbc

From Michael Paesold
Subject Re: JDBC and fetching the OID of an insert
Date
Msg-id 020601c25f1e$a7dde530$4201a8c0@beeblebrox
Whole thread Raw
In response to JDBC API Tests  (Al Sutton <al@alsutton.com>)
Responses Re: JDBC and fetching the OID of an insert
List pgsql-jdbc
Dave Cramer wrote:

> There is or was actually a method in the driver ResultSet.getLastOID
> which allowed you to do this.You will have to cast the resultset into a
> AbstractJdbc(x)ResultSet, where x is the version; but Daryl's way is
> much better since oid's can wrap, and there is a possiblity that they
> don't exist ( you can turn them off in postgres).
>
> Dave

I don't really care that oid's can wrap. I don't need them as sequences.
Instead I was just looking for the easiest way to get a reference to the row
I just inserted.

So my considerations about getGeneratedKeys() would only work if oid's are
not turned off -- very bad for a driver...

Michael



pgsql-jdbc by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: JDBC and fetching the OID of an insert
Next
From: Dave Cramer
Date:
Subject: Re: JDBC and fetching the OID of an insert