Hi,

> AFAIK, JDBC does not have a "CommitRetaining" function. (Neither does
> ADO/OLEDB
> if I understand correctly).

Actually ADO/OLE DB supports CommitRetaining. You simply need to set
the transaction attributes of the connection object to include
"adXactCommitRetaining" and when you call CommitTrans, it's supposed
to perform a CommitRetaining.

Here's Microsoft's link for more details:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaenumnz_20.asp


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)