Received: from mgw00.swol.de (mgw00.swol.de [195.238.142.133])
	by hub.org (8.10.1/8.10.1) with SMTP id e6IJ84h74408
	for <pgsql-novice@postgresql.org>; Tue, 18 Jul 2000 15:08:05 -0400 (EDT)
Received: (qmail 24434 invoked from network); 18 Jul 2000 19:06:31 -0000
Received: from blum20.swol.de (HELO nasen2) (195.238.140.52)
	by mgw00.swol.de with SMTP; 18 Jul 2000 19:06:31 -0000
From: ChristophSchmidt <cs.hilzingen@swol.de>
Reply-To: cs.hilzingen@swol.de
To: Joachim Achtzehnter <joachim@kraut.bc.ca>, pgsql-novice@postgresql.org
Subject: Re: [INTERFACES] Connection.setBytes()
Date: Tue, 18 Jul 2000 21:06:06 +0200
X-Mailer: KMail [version 1.0.17]
Content-Type: text/plain
References: <Pine.WNT.4.21.0007181149250.131-100000@van4>
MIME-Version: 1.0
Message-Id: <00071821101000.00418@nasen2>
Content-Transfer-Encoding: 8bit
X-KMail-Mark: 
X-Archive-Number: 200007/97

Am Die, 18 Jul 2000 schrieben Sie:
> On Tue, 18 Jul 2000, Matt Fair wrote:
> >
> > I want to set an array of bytes to a prepared statement, but it throws a
> > null pointer exception.
> 
> Did you turn off autocommit? BLOB code must run in the context of a
> transaction. I believe autocommit defaults to true, so you must explicitly
> set it to false and call commit at the end of your transactions.
> 
> Joachim

Hi, 
where is the point to turn autocommit off ? 
(how do you turn it off )
I am new to PREPARED STATEMENT...
Where can i find the documentation ? 
How much more efficient is it ?
Is it similar to stored procedures/functions ? 

cs