Getting oid after insert

From: Zak McGregor <zak(at)mighty(dot)co(dot)za>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Getting oid after insert
Date: 2003-08-28 02:19:48
Message-ID: 20030828041948.57675557.zak@mighty.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all

I am struggling to get the following code bit to work. It is supposed to be part
of getting the oid of the last insert. Can anyone see what I'm doing wrong
please? (Apart from using Java I mean....)

Thanks
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStatement);
org.postgresql.ResultSet result =
(org.postgresql.ResultSet)stmt.getResultSet();
String statusString =result.getStatusString();
System.out.println( "Status string returned: "+statusString );

I get the following error:

***Exception:
java.lang.NullPointerException
java.lang.NullPointerException
at celerity.DBase.executeSQL(DBase.java:82)
at DBTest.main(DBTest.java:16)

it does compile fine. Removing all the above lines and leaving just this:
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStatement);

inserts the rows fine.

Thanks

Ciao

Zak

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-08-28 02:22:58 Re: Java not running under Linux
Previous Message Joseph Shraibman 2003-08-28 01:56:06 Re: FATAL: Socket command type A unknown