Re: Problems with getLastOID

Or even better cast to org.postgresql.PGStatement
But maybe the getLastOID() is not in that interface for all versions?
It is in mine anyway...


Anders

* Dave Cramer (Dave@micro-automation.net) wrote:
> Gabriel,
>
> Ya, you have to cast the statement to a
> org.postgresql.AbstractJdbc1Statement to call that method
>
> this is an exerpt from grep OID ...
>
> AbstractJdbc1Statement.java:    public long getLastOID() throws
> SQLException
> AbstractJdbc1Statement.java:            return
> ((AbstractJdbc1ResultSet)result).getLastOID();
>
> DAve
>
> On Thu, 2003-02-20 at 08:47, 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
> --
> Dave Cramer <Dave@micro-automation.net>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org