Thread: Postgresql JDBC-Driver

Postgresql JDBC-Driver

From
Rudolpho Gian-Franco Gugliotta
Date:
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.

Thank you very much,

Rudolpho Gugliotta



Re: Postgresql JDBC-Driver

From
Kris Jurka
Date:

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



Re: Postgresql JDBC-Driver

From
Dave Cramer
Date:
This is not a viable solution, as oid's are not guaranteed to be unique,
nor are they primary keys; finally tables can be created without oid's,
in fact AFAIK, this will be the default in 7.5.

Dave
On Fri, 2004-03-05 at 08:25, 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.
> 
> Thank you very much,
> 
> Rudolpho Gugliotta
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 
> 
> !DSPAM:40c8fe6b9391076077350!
> 
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561