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

[MKF62]

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?

[JakeSkinner · Accepted solution]

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.