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@ritterdosreis.br>
> > To: pgsql-jdbc <pgsql-jdbc@postgresql.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@ritterdosreis.br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Faculdade Ritter dos Reis
> > www.ritterdosreis.br
> > felipes@ritterdosreis.br
> > Fone/Fax.: (51)32303328
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.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@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893
Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@ritterdosreis.br
Fone/Fax.: (51)32303328