Received: from s2.enthdimension.com.au (IDENT:root@[203.36.78.178])
	by hub.org (8.10.1/8.10.1) with ESMTP id e91Hvvp38296
	for <pgsql-sql@postgresql.org>; Sun, 1 Oct 2000 13:57:58 -0400 (EDT)
Received: (from root@localhost)
	by s2.enthdimension.com.au (8.9.3/8.8.7) id EAA06363
	for pgsql-sql@postgresql.org; Mon, 2 Oct 2000 04:56:21 GMT
Date: Mon, 2 Oct 2000 04:56:20 +0000
From: Craig May <craig.may@s2.enthdimension.com.au>
To: pgsql-sql@postgresql.org
Subject: currval
Message-ID: <20001002045620.B6334@s2.enthdimension.com.au>
Reply-To: craig.may@s2.enthdimension.com.au
References: <20001002045414.A6334@s2.enthdimension.com.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
In-Reply-To: <20001002045414.A6334@s2.enthdimension.com.au>;
	from craig.may@enthdimension.com.au on Mon, Oct 02, 2000 at
	04:54:50 +0000
X-Mailer: Balsa 0.8.0
X-Archive-Number: 200010/1

Hi,

I'm executing the following statements in series.  

insert into [tablename] values('a', 'b', 'c');

select currval('serial');

serial being the default index on [tablename]

The statement works fine from the command line, however, when executing via
jdbc, I'm getting no results back (null pointer).

Has anyone experienced this and have a solution?

Regards,
Craig May

Enth Dimension
http://www.enthdimension.com.au