Geoprocessing service with insert/update cursors - how to have multiple users?

199
1
Jump to solution
03-15-2018 08:43 AM
MollyFoley
Regular Contributor

I have a python script that I would like to publish as a geoprocessing service, but it contains many update and insert cursors to update database tables. Since instances of these cursors cannot occur simultaneously, how do you manage having multiple users possibly using it at the same time? I would assume versioning of the database, but then isn't a lock made on the database when you save the edits to the default database? Does anyone have a quick arcpy sample of versioning?

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

Hi Molly,

Take a look at the Editor example 2 in the following link:

Editor—Help | ArcGIS Desktop 

If you want to apply the edit to a specific version, make sure your database connection is connecting to that version.  You can change the version by right-clicking on the geodatabse > Geodatabase Connection Properties.

View solution in original post

0 Kudos
1 Reply
JakeSkinner
Esri Esteemed Contributor

Hi Molly,

Take a look at the Editor example 2 in the following link:

Editor—Help | ArcGIS Desktop 

If you want to apply the edit to a specific version, make sure your database connection is connecting to that version.  You can change the version by right-clicking on the geodatabse > Geodatabase Connection Properties.

0 Kudos