[Zope-DB] DCOracle2 and multiple SQl statements

[Smith, Neil]

Dieter Maurer wrote:

>By this exception handling, you take over full responsibility.
>
>Raise another exception if you want the transaction to be aborted
>If you do nothing special after you catched the exception,
>Zope's transaction (and the one of your database) is commited.

Thanks for that.  Unfortunately I can't raise an exception as any error
pages don't get passed on by our webthority proxy and I've not yet figured
out yet how to substitute a standard_error_message with a status that will
get through.  I've tried REQUEST.setStatus but I still got an unhelpfull
error page from the proxy rather than the real error page I wanted.  Anyway,
I've just added another method that does a rollback and called that from my
exception handling and it seems to do the trick.

Cheers

Neil
**********************************************************************
 
The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it.
    
If you have received this e-mail in error, please notify postmaster@npower.com (UK 01384 275454) and delete it immediately from your system.
    
Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.

Npower Limited
Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277

This e-mail may be sent on behalf of a member of the Innogy plc group of companies.

**********************************************************************