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

ional? Thanks for listening. My research on other threads has not given me much hope, but maybe things have changed recently? -- 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

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

Gregory Stark wrote: "Tyson Lloyd Thwaites" <[EMAIL PROTECTED]> writes: Normally if we catch the exception, other dbs (Oracle, MSSQL) will let us keep going. How do you catch exceptions in these other dbs? plain java try/catch. In other dbs, if I am in a

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

lumn's datatypes do not match ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Tyson Lloyd Thwaites Lead Software Developer Allianza Services Pty Ltd M: 0404 456 858 P: (+618) 8232 5525 F: (+618) 8232 8252 W: w

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

The auditing is an interesting question, to which I do not have an answer. Seems impossible to do in a transaction, by definition (ie not product specific). Thoughts? We do this with MSSQL. I have never given it a second thought until now. If anything goes wrong we send an audit event, usua

Re: [GENERAL] [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 d

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

ver handling the exception and doing something else instead, the 'something else' also threw an exception (txn is aborted), which propagated to the client end. UPDATE: Webb has proposed that this behaviour may be MSSQL misbehaving. -- Tyson Lloyd Thwaites Lead Software Developer Alli

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

tead, the 'something else' also threw an exception (txn is aborted), which propagated to the client end. UPDATE: Webb has proposed that this behaviour may be MSSQL misbehaving. -- Tyson Lloyd Thwaites Lead Software Developer Allianza Services Pty Ltd M: 0404 456 858 P: (+618) 82

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

Gregory Stark wrote: "Tyson Lloyd Thwaites" <[EMAIL PROTECTED]> writes: Gregory Stark wrote: "Tyson Lloyd Thwaites" <[EMAIL PROTECTED]> writes: Normally if we catch the exception, other dbs (Oracle, MSSQL) will let us keep going.

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

which, I presume, is Java?). You may be best reworking your transactions, but in order to clear up the confusion you will probably need to post some actual code here (we can handle it, don't worry...). -W -- Tyson Lloyd Thwaites Lead Software Developer Allianza Services Pty Ltd M: 0404 456 85

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

Greg Smith wrote: On Fri, 17 Aug 2007, Tyson Lloyd Thwaites wrote: It looks like it would be best if we re-worked our transactions and controlled them manually for the portions that need it. I am glad you have moved so quickly through grief and into acceptance. Heh heh - maybe I'v

[GENERAL] Transaction auto-abort causes grief with Spring Framework

ional? Thanks for listening. My research on other threads has not given me much hope, but maybe things have changed recently? -- 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