Transactions Handling across ArcSDE and Sliverlight -

[LakshmananVenkatesan]

Hi All,

This is more of design question.  We have big enterprise application developed using ESRI Sliver light 2.1 and ArcGIS Server 10. We are using oracle database 10g and industry specific data model.
Shapes are stored in ArcSDE layer (not a feature class - not registered with SDE) and attributes in relational tables. We have no choice for customizations

We are using custom Geo processing service to do perform spatial operations from client and database inserts (only used for shape insert).We are also using third party product to create EDM (entity data model ) at client side and do the all non-shape database operations. This third party product DOES NOT support database transactions. We are mainly using this product to avoid WCF service or other methods to do DB operations being enterprise application.

Now, we have a use case - where user will draws the shape and enter the attributes and it needs to be saved to the database.

Application architecture is  that the shape will be passed as record set to custom GP tools and which will insert into ArcSDE layer using ArcSDE connection. Attribute data are inserted using third party product into the database.

Now, we have handle the distributed transactions, due to some issue[oracle/network], when the attributes data failed to insert the records into database, we need to roll back the shapes as well. Similarly when shapes failed to insert, attributes needs to be rolled back. Attributes information stored in 5 to 6 tables.

Question - How to handle such scenario i.e. distributed transactions?. Since shape is inserted ArcSDE layer (not a feature class) and attributes in relational table?

I have gone through ITransactions objects and other ways of handling but none of the idea seems to be satisfactory. Can some provide some idea on this issue?

Application architecture CANNOT be revised at this moment. All I need to know best way to maintain transactions and remove data inconsistency in best optimal way.

Please let me know if you require any clarifications or additional inputs if my message is not clear enough.

Please advice me on this

Regards
SR

[RexHansen]

SR-

   It's not clear from your description of the problem that this is related to the ArcGIS API for Microsoft Silverlight or WPF.   Can you provide additional details on how the API is being used in a way that impacts this scenario?   You may want to try the ArcSDE and geodatabase forum for issues dealing with transactions and databases: http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE

[LakshmananVenkatesan]

SR-

   It's not clear from your description of the problem that this is related to the ArcGIS API for Microsoft Silverlight or WPF.   Can you provide additional details on how the API is being used in a way that impacts this scenario?   You may want to try the ArcSDE and geodatabase forum for issues dealing with transactions and databases: http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE

Hi Rex,

Thanks for your response.

The issue described is about ArcGIS Sliverlight 2.1 API. As said above, we have developed big enterprise application using ArcGIS SL 2.1 and third party product to generate EDM (entity data model) using oracle as DB. We have our custom geoprocessing service which does all spatial operations.

Let me put my question in a simple way

I want to insert only to attributes of a geometry to a table using sliver light
I want to insert a geometry using Geo processing tool 

Both are different channels of communications and have to handle the transactions


Is that clear and make sense.