The WebdavResource client has implemented the Microsoft tx extensions
eg. startTransaction(), abortTransaction() and commitTransaction()
methods. It takes a timeout for the transaction and a resource parameter
since it locks the resource as part of the process of maintataining the
external transaction. I found problems if I tried to do
startTransaction() on resources that may be in contention during the
course of a request as it seemed to cause more contention -- though I
didn't investigate too deeply and it could have been other issues.
However I found that if I specified a non-existent and thread-unique
resource to use for these transaction calls then it worked a little
better and I didn't get so many -911 conflict errors from DB2. The
non-existent resource is created as a lock-null resource for the
duration of the transaction.

        startTransaction("/files/<thread-id>", <timeout>");

As for the DB I've found that in the current configuration
(READ_COMMITTED) for DB2 that it blocks all access to modified tables
from outside of the transaction. So threads will wait until a tables
changes have been committed before the db will allow another transaction
to read that data. It is safe but it tends to be slow since an external
transaction has tended to include a lot of changes for us and so we have
had to contend with -911 errors and retry frequently.

Warwick


> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Christian Schwarz
> Sent: Tuesday, July 12, 2005 9:15 AM
> To: slide-user@jakarta.apache.org
> Subject: How-to use transactions over WebDAV
> 
> 
> 
> Hi!
> 
> I'm a newbie to Slide and I have one simple question, about 
> which I can't 
> find any information on the Slide website or on the Internet:
> 
> How can one use Slide's transaction features over WebDAV?
> 
> It would be nice, if one could start a transaction, then edit 
> arbitrary 
> documents on the WebDAV server and then commit or rollback the whole 
> transaction.  Until the transaction is committed or canceled, 
> the changes 
> should not be visible to other users (similar to how this 
> works in an SQL 
> DB).
> 
> Is this possible in Slide?
> 
> 
> Thanks,
> 
> Chris
> 
> --          _,,     Christian Schwarz
>             / o \__   [EMAIL PROTECTED]
>             !   ___;   [EMAIL PROTECTED], [EMAIL PROTECTED]
>             \  /
>    \\\______/  !        PGP-fp: 8F 61 EB 6D CF 23 CA D7  34 
> 05 14 5C C8 DC 22 BA
>     \          /         http://schwarz-online.com
> -.-.,---,-,-..---,-,-.,----.-.-
>    "DIE ENTE BLEIBT DRAUSSEN!"
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to