cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: How to do manual db commits?
Date Fri, 19 Sep 2003 07:45:50 GMT
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.

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message