RDS in ASP and a custom business object (VB) 
Author Message
 RDS in ASP and a custom business object (VB)


we are using RDS to retrieve data from an Oracle database and display it on
a web page. To retrieve and update the data from the database we use a user
defined business object which uses ADO to retrieve the datasets.

To update the data a method of the business object gets the modified record
set (with adMarshalModifiedOnly) and calls UpdateBatch().

The first time the UpdateBatch()-Method succeeds, the second time the method
fails with Error 80040e38: "Method 'UpdateBatch()' for object '_Recordset'
failed." The status-Property of the recordset is set to 2050, which means
adModified + adConcurrencyViolation.

That seems to me that Oracle means, someone else has modified the record and
I cannot write back the recordset. But nobody else modified the recordset
except my own method "UpdateBatch()" in the first time. I think that's why
the recordset is disconnected and the second time I come along with the
disconnected recordset the data in the database is newer than mine and
therefore I get the ConcurrencyViolation.

One solution would be to refresh the recordset after every UpdateBatch, but
this cannot be the right solution because it would slow down the performance
too much.

Any ideas?


Andre Fuechsel                              Phone:  +49 221 8299 228
SEMA GROUP Deutschland GmbH                 Fax:    +49 221 8299 288

                            < http://www.*-*-*.com/ >

Fri, 05 Oct 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. rds with custom business object

2. How To Use Implemented Interface with RDS and Custom Business Object

3. RDS and custom business objects

4. Passing Form Fields to VB.NET Custom Business Object in an ASP.NET Code Behind Page

5. Custom Business Object Problem

6. Accessing a custom data type in a vb object from ASP

7. Returning Dataset to ASP.NET from .NET Component / Business Object Serialization

8. Using Collections in Business Objects/Transaction Server/ASP

9. Using Collections in Business Objects/Transaction Server/ASP

10. Custom Business Objects => why use RDS?

11. Custom Business Objects => why use RDS?

12. use custom ActiveX com object in ASP


Powered by phpBB® Forum Software