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@xxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxxxxxxxx>
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html