Re: just curious

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: just curious
Date: 2002-09-17 11:52:31
Message-ID: 1032263551.1323.1.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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
--

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message H. Meyer 2002-09-17 12:01:22 Postgres 7.3b1 + JDBC3 (2002-09-05) truncates SQL commands?
Previous Message Barry Lind 2002-09-17 01:37:19 Re: just curious