[mapserver-users] WFS: msMSSQL2008LayerGetShapeRandom bad shape: 1
Tamas Szekeres
szekerest at gmail.com
Wed Aug 12 13:59:12 PDT 2009
Hi,
You've probably run into the same problem which I've already fixed (in trunk
and branch-5-4) 2 days ago.
For more details see:
http://trac.osgeo.org/mapserver/ticket/3082
Windows binary packages (containing the fix) can be downloaded at:
http://vbkto.dyndns.org:1280/sdk/Default.aspx
Best regards,
Tamas
2009/8/12 D Boyd <davidboyd at ntlworld.com>
>
> Hi folks,
>
> I'm having a little trouble creating a WFS that takes data from a MS SQL
> 2008 database. I have a table that stores points of interest, the table has
> a unique field (PointID) and a geometry field (PointPos) that stores the
> location.
>
> Previously I created a WMS that serves a map with these points drawn on
> which worked fine, with the WFS however none of the points are being
> returned in the feature collection. The following is displayed in the error
> log:
>
> Wed Aug 12 15:55:11 2009].450000 in msMSSQL2008LayerGetItems (find column
> names)
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerInitItemInfo called
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape called for
> record
> = 1
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape: select
> convert(varchar(max), PointID),convert(varchar(max),
> PointIdentifier),convert(varchar(max), PointDate),convert(varchar(max),
> PointClass),convert(varchar(max), PointSubClass),PointPos from Points where
> PointID = 1
> [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShapeRandom bad shape:
> 1
> [Wed Aug 12 15:55:11 2009].450000 mapserv request processing time
> (msLoadMap
> not incl.): 0.372s
>
> The getshape query in is returning the correct row with the PointPos in hex
> (tested SQL managment studio).
>
> The layer is as follows:
>
> LAYER
> NAME "PointData"
> DEBUG 5
>
> METADATA
> wfs_title "Point data test"
> gml_featureID "PointID"
> wfs_version "1.0.0"
> wfs_typename "PointData"
> END
>
> CONNECTIONTYPE PLUGIN
> TYPE POINT
> PLUGIN "C:/mapserver/msplugin_mssql2008.dll"
> CONNECTION "sql connection string"
> DATA "PointPos FROM Points"
>
> STATUS ON
>
> PROJECTION
> "init=epsg:27700"
> END
> DUMP TRUE
>
> CLASS
> STYLE
> COLOR 0 0 255
> END
> END
> END
>
> Any help with this issue would be greatly apreciated!
>
>
>
> --
> View this message in context:
> http://n2.nabble.com/WFS%3A-msMSSQL2008LayerGetShapeRandom-bad-shape%3A-1-tp3431353p3431353.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090812/f6106361/attachment.htm>
More information about the MapServer-users
mailing list