Received: from crowfix.com (qmailr@crowfix.crowfix.com [207.228.46.42]) by
	hub.org (8.8.8/8.7.5) with SMTP id UAA02643 for
	<pgsql-interfaces@postgresql.org>;
	Sat, 9 May 1998 20:16:10 -0400 (EDT)
Received: (qmail 19434 invoked by uid 501); 10 May 1998 00:16:11 -0000
Date: 10 May 1998 00:16:11 -0000
Message-ID: <19980510001611.19433.qmail@crowfix.com>
From: Felix Morley Finch <felix@crowfix.com>
To: pgsql-interfaces@postgresql.org
Subject: Problem with jdbc, nextval ('myseq'), and rs.getInt (1) - SOLVED
X-Mailer: VM 6.34 under Emacs 20.2.1

Well, heck, if I ever need proof I'm not perfect, I just got it :-)

I had this code which gave me a null pointer exception with clumn 1,
or SQLException for column 0:

	seq.execute ("SELECT nextval ('myseq')");
	ResultSet rs = seq.getResultSet ();
	id = rs.getInt (1);

The problem was, I had forgotten to include this statement --

	rs.next ();

which makes it all work fine.

Doh!

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  PGP = 91 B3 94 7C E9 E8 76 2D   E1 63 51 AA A0 48 89 2F  ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o