Return-Path: 
 <derby-dev-return-2066-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 39392 invoked from network); 4 Feb 2005 14:23:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 4 Feb 2005 14:23:58 -0000
Received: (qmail 69852 invoked by uid 500); 4 Feb 2005 14:23:57 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 69821 invoked by uid 500); 4 Feb 2005 14:23:57 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-dev-help@db.apache.org>
list-unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
list-post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 69808 invoked by uid 99); 4 Feb 2005 14:23:56 -0000
X-ASF-Spam-Status: No, hits=0.3 required=10.0
	tests=FORGED_RCVD_HELO,UPPERCASE_25_50
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from e35.co.us.ibm.com (HELO e35.co.us.ibm.com) (32.97.110.133)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 04 Feb 2005 06:23:55 -0800
Received: from d03relay04.boulder.ibm.com (d03relay04.boulder.ibm.com
 [9.17.195.106])
	by e35.co.us.ibm.com (8.12.10/8.12.9) with ESMTP id j14ENrZ7274604
	for <derby-dev@db.apache.org>; Fri, 4 Feb 2005 09:23:53 -0500
Received: from d03av02.boulder.ibm.com (d03av02.boulder.ibm.com
 [9.17.195.168])
	by d03relay04.boulder.ibm.com (8.12.10/NCO/VER6.6) with ESMTP id
 j14ENrBC273002
	for <derby-dev@db.apache.org>; Fri, 4 Feb 2005 07:23:53 -0700
Received: from d03av02.boulder.ibm.com (loopback [127.0.0.1])
	by d03av02.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j14ENqHg024148
	for <derby-dev@db.apache.org>; Fri, 4 Feb 2005 07:23:52 -0700
Received: from debrunners.com (sig-9-48-116-7.mts.ibm.com [9.48.116.7])
	by d03av02.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j14ENqhK024139
	for <derby-dev@db.apache.org>; Fri, 4 Feb 2005 07:23:52 -0700
Message-ID: <42038552.8030300@debrunners.com>
Date: Fri, 04 Feb 2005 06:23:14 -0800
From: Daniel John Debrunner <djd@debrunners.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.4.1) Gecko/20031008
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: Spatial Datablade for Derby (inital version)
References: <89f845e805020321586efcd5ca@mail.gmail.com>
 <42036D5D.6010709@sbcglobal.net>
In-Reply-To: <42036D5D.6010709@sbcglobal.net>
X-Enigmail-Version: 0.76.8.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kathey Marsden wrote:


> In ij you just need to turn autocommit off (once) and then the
> transaction will begin automatically.
>
> ij> autocommit off;
> ij> <statement>;
> ij><statement>;
> ij>  COMMIT;
> ij> <statement>;
> ij> COMMIT;


Just to note that the COMMIT is an ij command and not a SQL statement in
 Derby. Derby only supports commit through JDBC auto commit and
Connection.commit().

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFCA4VSIv0S4qsbfuQRAoQEAJ0V5j91kMiQzhvobZKRAuVUvN8jEgCbB1Rt
prLXJCs7E6agmzeZVEU7YS0=
=5sq2
-----END PGP SIGNATURE-----