topic Unlocking a FeatureClass after edits in ArcObjects SDK Questions

Unlocking a FeatureClass after edits

SachaTousignant — Tue, 12 Jun 2012 13:32:47 GMT

Hello everyone,

I'm trying to see if it's possible to unlock my FeatureClass after I added some features or modified some.

Here's some of the main lines :

IFeatureBuffer featureBuffer = infosXML.FeatureclassSitesReference.CreateFeatureBuffer(); IFeatureCursor cursorReferenceInsert = infosXML.FeatureclassSitesReference.Insert(true); featureBuffer.Shape = siteCourant.ShapeCopy; cursorReferenceInsert.InsertFeature(featureBuffer); cursorReferenceInsert.Flush();

Right now after doing this code, it locks the table from the others users.

EDIT :: It seems to be locked only when adding new features by either the way with FeatureBuffer + FeatureCursor or with FeatureClass.createFeature()
When modifying existing features and storing the changes, it doesn't lock the table.

Re: Unlocking a FeatureClass after edits

ThavitinaiduGulivindala — Tue, 12 Jun 2012 14:28:54 GMT

try releasing

featureBuffer and cursorReferenceInsert objects
e.g. in .Net, we can write Marshal.ReleaseComObject(cursorReferenceInsert)

Re: Unlocking a FeatureClass after edits

SachaTousignant — Wed, 13 Jun 2012 11:22:28 GMT

try releasing
featureBuffer and cursorReferenceInsert objects
e.g. in .Net, we can write Marshal.ReleaseComObject(cursorReferenceInsert)

Tyvm, I didn't know about it, I'll def try it out.

Worked out, thx alot! +1

Re: Unlocking a FeatureClass after edits

DuncanHornby — Sun, 12 Dec 2021 04:38:25 GMT

Another way to release cursors is using the USING statement and ComReleaser. See the VB code below

' For ArcGIS 10 using VS 2010 you need to import the following
Imports ESRI.ArcGIS.ADF.Connection.Local
Imports ESRI.ArcGIS.ADF 
Dim pQueryFilter As IQueryFilter 
pQueryFilter= New QueryFilterClass
pQueryFilter.WhereClause = "ID = 1"
Using releaser As New ComReleaser 
    Dim pFeatureCursor As IFeatureCursor 
    pFeatureCursor = pFeatureclass.Update(pQueryFilter, True) 
    releaser.ManageLifetime(pFeatureCursor) 
    Dim pFeature As IFeature  
    pFeature = pFeatureCursor.NextFeature 
    While pFeature IsNot Nothing 
        ' Do something with pFeature 
        pFeatureCursor.UpdateFeature(pFeature) 
        pFeature = pFeatureCursor.NextFeature
     End While
End Using

Duncan