Re: Problems with getLastOID

Gabriel,

From the looks of the code posted, and the circumstances you are
reporting it looks like the following:

a) you are running the 7.3 jdbc drivers
b) you are running code written to the 7.2 jdbc drivers

The code below is casting the statement to an org.postgresql.Statement.
In 7.3 that interface was renamed to org.postgresql.PGStatement.

It should be as simple as changing:

long insertedOID = ((Statement)st).getLastOID();
to
long insertedOID = ((PGStatement)st).getLastOID();

(you might also need to change an import).

thanks,
--Barry

first last wrote:
> Hi everyone. I am new to this list so I will introduce myself before I
> ask anything.
>
> My name is Gabriel and I work as a developer. I first used Postgres
> during my dissertation at
> university and now I have chosen it for a project at work (not the
> first time I get to use it
> professionally). I like to use well tested and documented code :)
>
> Now for the question:
>
> I am accessing Postgres 7.2.1, the official Debian package in woody
> with Sun's JSDK 1.4.1
> and the 1.4 JDBC drivers from the Postgres site.
>
> I got an example from the libpgjava Debian package that I can not get
> to compile, it
> complains that:
> basic.java:90: cannot resolve symbol
> symbol : method getLastOID ()
> location: interface java.sql.Statement
> long insertedOID = ((Statement)st).getLastOID();
>
> I used javap on java.sql.Statement and I can't find getLastOID nor any
> other method that will return me the ID of the last inserted.
>
> Any help would be welcome, I will need the id soon.
>
> Thanks very much
>
> Gabriel
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>