Problem with PGStatement.getLastOID() - Mailing list pgsql-jdbc

From ListMan
Subject Problem with PGStatement.getLastOID()
Date
Msg-id 6.0.1.1.0.20031202003503.01cb8998@tuta.hut.fi
Whole thread Raw
Responses Re: Problem with PGStatement.getLastOID()  (Oliver Jowett <oliver@opencloud.com>)
Re: Problem with PGStatement.getLastOID()  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi!

I hope you can help me with a problem with the jdbc-driver devel version
(need it for 7.4).

With driver version pg73jdbc the following works fine:

int rowCount = -1;
long insertedOid = -1;
Connection con = null;
Statement stmt = null;

con = sec.getConnection(); // gets pooled connection
stmt = con.createStatement();
con.setAutoCommit(false);
rowCount = stmt.executeUpdate(query);
con.commit();
insertedOid = ((org.postgresql.PGStatement)stmt).getLastOID();
con.setAutoCommit(true);
con.close();

With devel version I get ClassCastException on row with insertedOid =
((org.postgresql.PGStatement)stmt).getLastOID();

Version 73 drivers were tested against our production server which is
running postgres 7.3 and devel drivers were tested against my own own
machine running 7.4 on Cygwin.

I hope you can help me with this.

B Rgds,
JariP


pgsql-jdbc by date:

Previous
From: groups@ezotyrik.org (Ezotyrik)
Date:
Subject: Backend Protocol Examples?
Next
From: Oliver Jowett
Date:
Subject: Re: Problem with PGStatement.getLastOID()