From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Amaresh Wakkar <babu_moshay(at)indiatimes(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: 25P02, current transaction is aborted, commands ignored |
Date: | 2006-04-02 12:55:01 |
Message-ID: | 442FC9A5.6000207@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Amaresh Wakkar wrote:
> Thanks!!
>
> The code works fine after I added savepoints around "Okay,even if
> fails" statement.
>
> What is the idea behind taking this route(i.e all statements ignored
> till end of block) though? Is there any archive thread discussing this?
There should be tons, it comes up regularly whenever someone ports an
app from Oracle..
> In this particular case, the autocommit is off and the statement has
> failed so there is no risk of changes being made permanent(presumable PG
> would rollback at database level the changed buffers etc.,) unless the
> commit() method is invoked. Why then explicit rollback is needed? Is it
> not best if it is left to programmer to handle this in exception
> handling code?
There are arguments both ways. To some extent it depends on who you
trust more to get the code right: the DB developer (once) or the app
developer (once per query).
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Amaresh Wakkar | 2006-04-02 14:54:10 | Re: 25P02, current transaction is aborted, commands ignored |
Previous Message | Dave Cramer | 2006-04-02 12:36:59 | Re: 25P02, current transaction is aborted, commands ignored |