Re: Postgresql JDBC-Driver

On Fri, 5 Mar 2004, Rudolpho Gian-Franco Gugliotta wrote:

> Hi,
>
> i'm using the jdbc postgresql driver. I need to fetch the oid of a just
> insertet row
> (getGeneratedKeys() feature). That' why i ask you to provide me the
> source code
> to implement this feature.It would be glad if you tell me how and where
> to get
> these sources.
>

The driver source is included in the main source tree for the 7.4 series,
but for the upcoming 7.5 release the driver is being developed
independently here:
http://gborg.postgresql.org/project/pgjdbc/projdisplay.php

Some discussion of the problems with implementing getGeneratedKeys is
here:
http://archives.postgresql.org/pgsql-jdbc/2003-12/threads.php#00193

Finally you don't necessarily need to implement getGeneratedKeys if you
don't mind using some pg specific code along the lines of the following:

Statement stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO t VALUES (1)");
long oid = ((org.postgresql.PGStatement)stmt).getLastOID();

Kris Jurka