On 19.Sep.2003 -- 09:45 AM, Christian Haul wrote:
> On 18.Sep.2003 -- 07:48 PM, Andrzej Jan Taramina wrote:
> > If you turn autocommit off in your database connection, how do you do manual
> > commits at appropriate spots using ESQL? SQLTransformer? Database Actions?
>
> Unless you are using a very restricted DBMS you need to commit on the
> very same connection as your transaction is on. Hence you must do it
> within the same esql:connection tag wich can have multiple
> esql:execute-query blocks. esql does not have a "commit-tag", so you
> would write a query that reads "commit work" or whatever SQL flavour
> your DBMS supports.
I should have added that doing manual commits may result in hanging
connections when processing of the XSP has terminated because of some
error and the commit / rollback didn't execute.
And just in case you were asking how to do manual commits with
database actions -- you can't really. One action invocation is one
transaction even if multiple rows / tables are affected. However, only
the query action would allow different operations like update / delete
in one TX.
As for the transformer, I don't know off head.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
