From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Hunter Hillegas <lists(at)lastonepicked(dot)com> |
Cc: | Postgre JDBC List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: getLastUID() In pgsql JDBC |
Date: | 2003-05-08 02:11:35 |
Message-ID: | 1052359895.2627.19.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
No, there's no javadoc for the code, but to answer your other question
it is in org.postgresql.PGStatement, just cast your statement object to
that, and call the getLastOID()
package org.postgresql;
import java.sql.*;
/* $Header:
/cvsroot/pgsql-server/src/interfaces/jdbc/org/postgresql/PGStatement.java,v 1.6 2002/09/08 00:15:28 barry Exp $
* This interface defines PostgreSQL extentions to the
java.sql.Statement interface.
* Any java.sql.Statement object returned by the driver will also
implement this
* interface
*/
public interface PGStatement
{
/*
* Returns the Last inserted/updated oid.
* @return OID of last insert
* @since 7.3
*/
public long getLastOID() throws SQLException;
public void setUseServerPrepare(boolean flag) throws SQLException;
public boolean isUseServerPrepare();
}
Dave
On Wed, 2003-05-07 at 22:02, Hunter Hillegas wrote:
> Hmmm... Yes, I am familiar with that SQL...
>
> I misspoke... I am looking for getLastOID()... What class is that a part of?
> Is there JavaDoc for the driver's classes?
>
> Thanks again,
> Hunter
>
> > From: Dave Cramer <Dave(at)micro-automation(dot)net>
> > Date: 07 May 2003 21:49:45 -0400
> > To: Hunter Hillegas <lists(at)lastonepicked(dot)com>
> > Cc: Postgre JDBC List <pgsql-jdbc(at)postgresql(dot)org>
> > Subject: Re: [JDBC] getLastUID() In pgsql JDBC
> >
> > Ya,
> >
> > select curval('sequence')
> >
> > will return the current value, and it is connection specific, in other
> > words if another connection increments it before you get the value you
> > will get your value.
> >
> > Dave
> >
> > On Wed, 2003-05-07 at 21:20, Hunter Hillegas wrote:
> >> Does this method exist in any of the pgsql JDBC drivers?
> >>
> >> We're testing out some auto-increment stuff for EJBs in JBoss and looking
> >> for the correct method...
> >>
> >> Also, is there a page or doc that details what is and isn't implemented in
> >> the pg jdbc driver?
> >>
> >> Thanks,
> >> Hunter
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 3: if posting/reading through Usenet, please send an appropriate
> >> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >> message can get through to the mailing list cleanly
> > --
> > Dave Cramer <Dave(at)micro-automation(dot)net>
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Jani Virta | 2003-05-08 08:05:29 | NullPointerException while closing connection with connectionpool |
Previous Message | Hunter Hillegas | 2003-05-08 02:02:08 | Re: getLastUID() In pgsql JDBC |