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