[mapserver-users] Using Geopackage 1.0 & Spatial view

[pe_lord]

I've created a view joining 2 tables (1:M). 
This view is well recognized with QGIS 3.0 & GDAL 2.2.4 (OsGeo4W)

When I use this view in mapserver :
CONNECTIONTYPE OGR
CONNECTION "mygeopackage.gpkg"
DATA "v_my_view"

I get 
msOGRFileOpen(): OGR error. GetLayer(v_my_view) failed for OGR connection.
Check logs.

Here my log(debug 5 & "CPL_DEBUG" "ON").

... msOGRFileOpen(mygeopackage.gpkg)...
... OGROPen(/my_path/mygeopackage.gpkg)
... msConnPoolRegister(v_my_view,mygeopackage.gpkg,0x1dfd3c0)
... msOGRFileOpen(): OGR error. GetLayer(v_my_view) failed for OGR
connection. Check logs.
... GetLayer(v_my_view) failed for OGR connection `mygeopackage.gpkg'.
... msConnPoolRelease(v_my_view,mygeopackage.gpkg,0x1dfd3c0)
... msConnPoolClose(mygeopackage.gpkg,0x1dfd3c0)
... msDrawMap(): Image handling error. Failed to draw layer named
'v_my_view'.
... freeLayer(): freeing layer at 0x1e02ac0.

Then, when I write this view as a table (well recognized with QGIS 3.0 &
GDAL 2.2.4 (OsGeo4W)) , everything is fine with Mapserver.

Seem like my view is crashing my OGR connection.

The only difference between my view and my tables is that my view do not
have gpkg_rtree_index associated?  I've tried from spatialite gui to Select
gpkgAddSpatialIndex(...). But I received this error :
cannot create AFTER trigger on view: v_my_view 

I use Mapserver 7.03 on RedHat.
I don't know which version of gdal is used with Mapserver...sorry


Pierre






--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html