topic Re: Is there a Quartz equivalent to AGSGDBTransaction? in ArcGIS Runtime SDK for iOS Questions

Is there a Quartz equivalent to AGSGDBTransaction?

ChristopherMilack1 — Sun, 25 Sep 2016 14:52:59 GMT

I'm not seeing this functionality in the Quartz SDK. Am I just missing it? Will it in the final release? If not, is there a recommendation or best practice from Esri for performing a series of edits as a transaction?

Re: Is there a Quartz equivalent to AGSGDBTransaction?

DiveshGoyal — Wed, 05 Oct 2016 19:39:30 GMT

We do plan on supporting transactions, but we haven't been able to get to it yet unfortunately.

Can you describe your workflow where it is needed?

Re: Is there a Quartz equivalent to AGSGDBTransaction?

ChristopherMilack1 — Thu, 06 Oct 2016 11:18:16 GMT

Our users go through a series of editing views to update attribution on tables as well as create and update geometries for feature classes. When they're finished with the process, we need to save all of those updates as a transaction otherwise we risk corrupting our database. We don't use esri relationship classes but we do have relationships in our database that we must maintain. In our largest workflow, we have 5 tables and one feature class that all need to be saved at the same time, as one transaction.

Re: Is there a Quartz equivalent to AGSGDBTransaction?

MichaelDavis3 — Wed, 12 Oct 2016 00:34:50 GMT

If you don't mind me asking - what is it about the data that requires you to save everything at the same time?

Could you persist some data throughout the editing view workflow to make sure everything is saved with the correct foreign keys in place to maintain your relationships?

Re: Is there a Quartz equivalent to AGSGDBTransaction?

ChristopherMilack1 — Wed, 12 Oct 2016 00:59:22 GMT

I have multiple records that together make up one transaction. If I insert three records but the fourth fails, then I have situation where I have an incomplete data or orphaned record. Saving the records and maintaining relationships is not the issue. The real problem is that I want either all of my records in the database or none at all.

Re: Is there a Quartz equivalent to AGSGDBTransaction?

MichaelDavis3 — Wed, 12 Oct 2016 01:10:23 GMT

Ahh - gottcha... what is the source of the failures? In my experience these are pretty infrequent once you get past the typical development issues.

You could chain the database saves together and roll them back manually if one fails -- basically delete the previously saved features if you hit an issue.

Re: Is there a Quartz equivalent to AGSGDBTransaction?

ChristopherMilack1 — Wed, 12 Oct 2016 02:12:41 GMT

They are infrequent but if it happens once in production then we have a problem. I've considered the approach you described, and it's certainly an option, but it would require bookkeeping for all create/update/delete operations which I would like to avoid. More importantly, if one of these manual rollbacks fails then we're still in a situation where we have corrupt data.

Re: Is there a Quartz equivalent to AGSGDBTransaction?

ChristopherMilack1 — Tue, 21 Feb 2017 14:22:58 GMT

Divesh Goyal‌ Ryan Olson‌ Any update on this? Any chance this will be in the next release of the SDK? Thanks!

Re: Is there a Quartz equivalent to AGSGDBTransaction?

RyanOlson1 — Tue, 21 Feb 2017 21:44:59 GMT

No, it is not in v100. Looks like it might make it into an update in the future, probably not the next one.