[mapserver-users] How use ogr provider with spatialite "read only" clause

[Eichner, Andreas - SID]

According to msOGRFileOpen(mapogr.cpp:1194):
    hDS = OGROpen( pszDSSelectedName, MS_FALSE, NULL );
I would say that MapServer _always_ opens an OGR datasource readonly (See http://www.gdal.org/ogr__api_8h.html#a2da3630231780d519543d1679c83e62f ).

> -----Original Message-----
> From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org]
> On Behalf Of Andrea Peri
> Sent: Wednesday, January 10, 2018 12:29 PM
> To: mapserver-users at lists.osgeo.org
> Subject: [mapserver-users] How use ogr provider with spatialite "read
> only" clause
> 
> Hi,
> 
> Usually we use the spatialite db as ordinary datasource for ours
> mapserver wms.
> 
> 
> Now I discovered that the last versions of spatialite always test
> automatically the version of the DB sqlite and if verify that the db was
> create using an older spatialite version.
> 
> TRY TO UPDATE the spatialite system tables WHEN the connection was
> closed.
> 
> 
> This probably is a good strategy for an ordinary desktop application.
> 
> But more risk pendent when used on a mpaserver that could have more than
> one connection open on the same DB sqlite.
> 
> 
> To avoid this the standard solution used from the spatialite driver is
> to check if the DB is open in READ-ONLY mode.
> 
> 
> And avoid to write and update the db when it is in read-only mode.
> 
> 
> So my trouble now is how the change the usual connection string in the
> mapfile to say to the OGR driver to open the sqlite/spatialite using the
> "read-only" mode.
> 
> Is this possible ?
> 
> 
> Many thx
> 
> 
> A.
> 
> 
> --
> 
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
> 
>