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
[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]
