<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Meinrad,</p>
<p>I don't know anything about MapGuide, but I know a little about
SQLite, so in lieu of anyone else answering...</p>
<p>A locked SQLite database is like a connection to a regular
(PostGIS/Oracle) database - the application will usually keep the
file locked open if it's going to be reading/writing from the
database because connecting to the SQLite database is relatively
expensive
(<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/3747232/how-expensive-sqlite3-connect-and-close-in-sqlite">https://stackoverflow.com/questions/3747232/how-expensive-sqlite3-connect-and-close-in-sqlite</a>).
So "prevention" of this locking is unlikely to be desirable.<br>
</p>
<p>Now if MapGuide has a way of "disconnecting" a layer, that's a
question for someone who knows MapGuide.</p>
<p>(Un-relatedly if there's anyone from OSGeo reading this - The
MapGuide website seems very outdated (10 year old documentation!)
and has a lot of dead OSGeo links, i.e. the links in "OSGeo
Community" - <a class="moz-txt-link-freetext" href="https://mapguide.osgeo.org/">https://mapguide.osgeo.org/</a>)<br>
</p>
<p>Cheers,</p>
<p>Jonathan<br>
</p>
<br>
<div class="moz-cite-prefix">On 2018-09-24 17:03, <a class="moz-txt-link-abbreviated" href="mailto:mwk5001@gmx.ch">mwk5001@gmx.ch</a>
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:trinity-55319896-d791-4494-a28c-a22b0ec9fcac-1537804990501@3c-app-gmx-bs47">
<div style="font-family: Verdana;font-size: 12.0px;">
<div> </div>
<div class="signature">Hi,</div>
<div class="signature"> </div>
<div class="signature">I'm using SQLite FDO and have the problem
that the databases get locked by MapGuide Open Source. If I
want to replace a database, I need to restart the MapGuide
service first.</div>
<div class="signature"> </div>
<div class="signature">Is there a setting to prevent this? Or a
command to instruct MapGuide to release the lock on a specific
database? How do you handle this?</div>
<div class="signature"> </div>
<div class="signature">Thank you and best regards,</div>
<div class="signature">Meinrad</div>
</div>
<!--'"--><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Discuss mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Discuss@lists.osgeo.org">Discuss@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/discuss">https://lists.osgeo.org/mailman/listinfo/discuss</a></pre>
</blockquote>
<br>
</body>
</html>