Received: from awcoldstream.com ([206.130.14.2]) by hub.org (8.8.8/8.7.5) with
	ESMTP id AAA27773 for <pgsql-interfaces@postgreSQL.org>;
	Thu, 7 May 1998 00:41:12 -0400 (EDT)
Received: from awcoldstream.com (206.248.140.66) by awcoldstream.com
	with ESMTP (Apple Internet Mail Server 1.1.1);
	Wed, 6 May 1998 23:38:51 -0500
Message-ID: <35513D62.FFD7979@awcoldstream.com>
Date: Wed, 06 May 1998 23:49:38 -0500
From: Anil Amarakoon <anil@server.awcoldstream.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Java Transaction
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi All!

How do I do transaction in Java
when I tried
resultset=statement.executeQuery("begin transaction);
resultset.close();
resultset = statement .executeQuery("select foo from bar where
myid=1000");

it does not return any results.

or do I have to do with
connection.setAutoCommit(false);
bla bla...
myconn.commit();

any information in this regard is highly appreciated.

Tks a lot

Anil