Re: [RESEND] Transaction auto-abort causes grief with Spring Framework

Martijn van Oosterhout wrote:

>On Fri, Aug 17, 2007 at 03:18:30PM +0930, Tyson Lloyd Thwaites wrote:
>
>
>>It seems like something that would be fairly easy to change... I don't
>>know. I read someone talking about putting automatic checkpoints on
>>every statement that goes through the jdbc driver to get around this
>>issue. Perhaps this is the only way... unless pg could be put in a mode
>>where it did this for you... like autocommit, but auto-checkpoint.
>>
>>
>
>FWIW, this is exactly how the psql client handles "ON_ERROR continue".
>There is resistance to building it into the protocol itself since the
>autocommit fiasco. The backward compatability issues are daunting and
>as pointed it can be handled adequately inside the driver
>(jdbc/odbc/etc).
>
>(That's not to say it couldn't be made easier for the clients also. For
>example as part of the query request have a flag that says: start
>savepoint prior to execution.)
>
>Have a nice day,
>
>
I am not familiar with the autocommit fiasco, but I can use my
imagination... :)

You mention it can be built into the driver - is this a 'could be' or
'has been', ie is this a mainstream practice, or would such a thing be
considered risky? I would think it would be wonderful to allow users to
choose to override this behaviour - and suffer the consequences if
necessary! It's like playing with the fsync setting... turn it off at
your own risk.

--
Tyson Lloyd Thwaites
Lead Software Developer
Allianza Services Pty Ltd

M: 0404 456 858
P: (+618) 8232 5525
F: (+618) 8232 8252
W: www.allianza.com.au