In some databases, the transaction context can be made independent of a single connection and can be picked up and put down by means of a global transaction ID without actually committing it. This is useful for 3-tier systems where the middle tier uses connection pooling, workflow systems where multiple users need to see a consistent view of the data while maintaining transactionality and concurrency control - and various other applications.
The SAP-DB team seem to think that implementing this feature in SAP-DB would require significant re-architecture in the DB kernel, and it isn't considered to be worth doing (presumably they haven't had a great deal of interest in this feature). There's a little snippet in the Wiki on the subject. Incidentally, this is pretty much my only significant wish-list feature for SAP-DB ... Nigel. -----Original Message----- From: Edo Bezemer [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 March 2003 3:56 a.m. To: Zabach, Elke; Craig Demyanovich; [EMAIL PROTECTED] Subject: RE: distributed transaction support Hi Distributed Transaction, isn't that a transaction that will be distributed to different databases/nodes? I have the opinion a transaction can never be shared by different users. BTW, Is SAPDB able to distribute a transaction to more databases? Cheers Edo -----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 26. Marz 2003 07:01 To: 'Craig Demyanovich'; [EMAIL PROTECTED] Subject: RE: distributed transaction support Craig Demyanovich wrote: > > I would like to know whether sapdb supports distributed > transactions, but I > haven't been able to find a definitive answer. If so, I > would like to try > to use it for a J2EE application that I'm developing; if not, > is support > planned and for what timeframe? Distributed transactions (transactions used by several sessions/users) are not available in SAP DB and are not planned. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
