editing a version of a Geodatabase through SQL from multiple sessions

VishUma

Hi all,

I am trying to edit a FeatureClass in a specific version of the GeoDatabase through SQL using versioned views. I call edit_version and send in the version name and "1" to start editing from one connection to the database. I open another connection to the database and call edit_version with the version name and "1", which ends up returning the following error

Msg 50000, Level 16, State 1, Procedure edit_version, Line 208

Lock conflict detected for state 26

Does this mean that a version can only be edited from one session at a time? Is this a limitation of editing geodatabases through SQL? This means that geodatabase versions cannot be edited by web applications. Since ArcMAP allows two users to edit the same version, does it mean that it is not a limitation if using the ArcObjects SDK?

Thank You,

Vish

JoshuaBixby

Sometimes the most important notes in documentation aren't where you expect them.  If you look at the Edit versioned data in SQL Server using SQL, specifically the Edit a named version section, the Purpose description for the create_version stored procedure states:  If you are editing named versions (versions other than Default), always edit your own, separate version; multiple editors cannot edit the same named version using versioned views.  It is for this reason the workflow described in the documentation shows creating a new version first.  Apparently, this isn't the case for the Default version, but I haven't tested it directly.