Received: from www.inreko.ee (www.inreko.ee [195.222.18.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB18hkF71491 for ; Fri, 1 Dec 2000 03:43:46 -0500 (EST) (envelope-from marko@l-t.ee) Received: from grue ([195.222.18.13] helo=grue.l-t.ee) by www.inreko.ee with esmtp (Exim 3.14 #2) id 141lq8-0005oS-00; Fri, 01 Dec 2000 10:46:44 +0200 Received: from marko by grue.l-t.ee with local (Exim 3.16 #1 (Debian)) id 141lwu-0001yd-00; Fri, 01 Dec 2000 10:53:44 +0200 Date: Fri, 1 Dec 2000 10:53:44 +0200 From: Marko Kreen To: tony Cc: pgsql-interfaces Subject: Re: currval() problem Message-ID: <20001201105344.A7506@l-t.ee> References: <3A1B11B4.1FA5AC73@uickarate.com> <3A1B16D4.76F6B49C@10happythings.com> <001a01c059a1$f9ffc6f0$32fea8c0@tonydesktop> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001a01c059a1$f9ffc6f0$32fea8c0@tonydesktop>; from tony@uickarate.com on Tue, Nov 28, 2000 at 08:16:08PM -0500 X-Archive-Number: 200012/1 X-Sequence-Number: 338 On Tue, Nov 28, 2000 at 08:16:08PM -0500, tony wrote: > Hello > > I have a problem with currval() through JDBC. > My nextval() updates the counter of sequences, but > currval() returns no value even after I call nextval(). > Both work fine when I try them through psql. > Have you encountered this problem before?? does this help? con.setAutoCommit(false); -- marko