Calling datasource.ReleaseResultSet(layer) did the trick.
From: Even Rouault [mailto:even.roua...@spatialys.com]
Sent: Tuesday, March 13, 2018 6:12 PM
Cc: Stephan Braeuer <stephan.brae...@bentley.com>
Subject: Re: [gdal-dev] Shape datafile locked
On mardi 13 mars 2018 10:01:48 CET Stephan Braeuer wrote:
> I am using GDAL with c# and run into a problem deleting datasource files
> after running ExecuteSQL.
> The key here is that a datasource is opened implicitly via the JOIN
> statement. An implicitly opened shapefile (here node3109.shp) remains locked
> after the datasource has been closed.
> Opening the file upfront does not help either. Here is the c# code snippet:
> using (DataSource datasource = OSGeo.OGR.Ogr.Open(pipeFile, 0))
> string statement =
> "SELECT p.id, n.grnd_lvl FROM pipe3109 p " +
> "LEFT JOIN 'node3109.shp'.node3109 n ON n.node_id = p.ds_node_id";
> using (Layer layer = datasource.ExecuteSQL(statement, null,
You probably need an explicit
here. As I don't think layers resulting from ExecuteSQL() are garbage collected
by the C# bindings (they are not by other binding languages)
> File.Delete(pipeFile); //ok
> File.Delete(nodeFile); //throws
> Anyone knowing a solution to avoid the lock?
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> gdal-dev mailing list
Spatialys - Geospatial professional services
gdal-dev mailing list