Skip site navigation (1) Skip section navigation (2)

Re: just curious

From: Barry Lind <barry(at)xythos(dot)com>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: just curious
Date: 2002-09-18 17:11:04
Message-ID: 3D88B3A8.5080100@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Felipe,

No you misunderstood the other messages on the list.  You certainly can 
setAutocommit() in the driver.  What you should not do in a 7.3beta1 
database is set the postgresql.conf parameter autocommit to off.  This 
is a server setting, not a jdbc setting.  The driver currently only 
supports the default server setting for autocommit.

thanks,
--Barry


Felipe Schnack wrote:
>    Hmm....... interessanting. Well, I heard in this list that I
> shouldn't set autocommit using JDBC driver setAutocommit() method right
> now... So, my better option now is set the database to work with
> autocommit=off right now?
> 
> On Mon, 2002-09-16 at 22:37, Barry Lind wrote:
> 
>>Felipe,
>>
>>I don't think the jdbc spec allows you to use batch opperations with 
>>autocommit set to true.
>>
>>--Barry
>>
>>Felipe Schnack wrote:
>>
>>
>>>Subject: [JDBC] just curious
>>>From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
>>>To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
>>>Date: 16 Sep 2002 16:40:32 -0300
>>>
>>> If I'm using pgsql with autocommit ON and I execute a batch of
>>>commands (executeBatch()), if one of the commands fails, what happens?
>>>The database will act like the batch is a transaction and will
>>>"rollback"?
>>>
>>>--
>>>
>>>Felipe Schnack
>>>Analista de Sistemas
>>>felipes(at)ritterdosreis(dot)br
>>>Cel.: (51)91287530
>>>Linux Counter #281893
>>>
>>>Faculdade Ritter dos Reis
>>>www.ritterdosreis.br
>>>felipes(at)ritterdosreis(dot)br
>>>Fone/Fax.: (51)32303328
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>>message can get through to the mailing list cleanly
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>>http://archives.postgresql.org
> 


In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2002-09-18 20:54:31
Subject: Re: Implementing JDBC3 methods (Was: JDBC and fetching the
Previous:From: Barry LindDate: 2002-09-18 17:08:14
Subject: Re: [GENERAL] Postgres 7.3b1 + JDBC3 (2002-09-05) truncates SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group