[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server
Tamas Szekeres
szekerest at gmail.com
Sat Mar 6 13:56:45 PST 2010
I've just applied a couple of fixes in both the development and the stable
branches with regards to the MSSQL2008 driver.
The details of the fixes have been added to.
http://trac.osgeo.org/mapserver/ticket/3058
Ready to use binaries containing the recent fixes are available at:
http://vbkto.dyndns.org/sdk/
Any feedback and further testing efforts would be helpful, before we issue
the next stable release 5.6.2 (hopefully in the next week)
Best regards,
Tamas
2010/3/3 Paul james <pauljame at gmail.com>
>
> Hi
> I´m sending a point table that I´m using to test...
>
>
> Layer definition :
> LAYER
> NAME Test
> METADATA
> "wms_title" "Test" ##required
>
> "wms_feature_info_mime_type" "text/html"
> END
> TYPE POINT
> STATUS ON
> INCLUDE "Connection.map"
> DATA "the_geom from tblGeo_Porto USING UNIQUE CodigoPorto USING
> SRID=0"
>
> TOLERANCE 14
> TEMPLATE "query.html"
>
> CLASS
> TEMPLATE "dummy"
> NAME "Test"
> STYLE
> SYMBOL 'test_15'
> COLOR 0 0 0
> ANTIALIAS TRUE
> END
> END
> END
>
> Nquery CGI call :
>
> http://localhost/cgi-bin-last/mapserv.exe?map=Map.map&mode=nquery&LAYERS=Test&mapext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&imgext=-54.463422851562+-28.5204328125+-54.155805664062+-28.267747265625&map_size=1221+670&imgxy=1221+670&imgbox=0+0+1221+670
>
> I got :
> Content-type: text/html
>
> Using Postgis (same code) works fine...
>
> If you need, I can send the GetFeatureInfo code as well... But I think it´s
> the same "bug" ...
>
> The db data is attached...
>
> Paul
>
>
>
>
> On Tue, Mar 2, 2010 at 8:01 PM, Tamas Szekeres <szekerest at gmail.com>wrote:
>
>> Paul
>>
>> It would be helpful to have some test data to reproduce your problem.
>>
>> In the meantime I've found an issue with regards of the query handling in
>> the sql2008 driver and working on a fix right now, however I'm not sure if
>> it is related to the problem of yours.
>>
>> Best regards,
>>
>> Tamas
>>
>>
>> 2010/3/2 Paul james <pauljame at gmail.com>
>>
>> Hi ...
>>>
>>> I have the same error here using Getfeature and Mssql2008... Works fine
>>> with Postgis connection ...
>>>
>>> My last test was using Getfeature with a Point Layer... The message
>>> returned was :
>>>
>>>
>>> Content-type: application/vnd.ogc.se_xml
>>>
>>> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
>>> <!DOCTYPE ServiceExceptionReport SYSTEM "
>>> http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
>>> <ServiceExceptionReport version="1.1.1">
>>> <ServiceException>
>>> </ServiceException>
>>> </ServiceExceptionReport>
>>>
>>> No error reported using DEBUG mode...
>>>
>>> The query generated was :
>>>
>>> SELECT convert(varchar(max), oid),convert(varchar(max),
>>> id),the_geom.STAsBinary(),convert(varchar(20), oid) from viw_test WHERE
>>> the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-62.4340041752662
>>> -11.1071026733531,-61.8187697837838 -11.1071026733531,-61.8187697837838
>>> -10.4918682818707,-62.4340041752662 -10.4918682818707,-62.4340041752662
>>> -11.1071026733531))',0)) = 1
>>>
>>> That query executed in Analyser return the right result:
>>> 0x010100000000917EFB3A104FC061A6ED5F598925C0
>>>
>>> Using CGI NQuery also doesnt work, returning :
>>> Content-type: text/html
>>>
>>> If you need more details, let me know...
>>>
>>> Paul
>>>
>>>
>>>
>>>
>>> On Tue, Mar 2, 2010 at 5:34 AM, Afroz Kannancheri <afrozk at gmail.com>wrote:
>>>
>>>>
>>>> Dear Tamas,
>>>> Heres the debug log obtained when i clicked on the polygon
>>>>
>>>> [Tue Mar 02 12:28:47 2010].113000 msMSSQL2008LayerOpen called
>>>> datastatement:
>>>> geom from region1 USING UNIQUE id USING SRID=4326
>>>> [Tue Mar 02 12:28:47 2010].113000 MSMSSQL2008LayerOpen -- shared
>>>> connection
>>>> not available.
>>>> [Tue Mar 02 12:28:47 2010].957000
>>>>
>>>> msConnPoolRegister(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>>> Security=false,01E39FC0)
>>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerParseData: unique
>>>> column =
>>>> id, srid='4326', geom_column_name = geom, table_name=region1
>>>> [Tue Mar 02 12:28:47 2010].957000 msMSSQL2008LayerFreeItemInfo called
>>>> [Tue Mar 02 12:28:47 2010].957000 in msMSSQL2008LayerGetItems (find
>>>> column
>>>> names)
>>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
>>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerInitItemInfo called
>>>> [Tue Mar 02 12:28:48 2010].113000 msMSSQL2008LayerWhichShapes called
>>>> [Tue Mar 02 12:28:48 2010].113000 query_string_temp:SELECT
>>>> convert(varchar(max), ID),convert(varchar(max),
>>>> name),convert(varchar(max),
>>>> flag1),convert(varchar(max), flag2),convert(varchar(max),
>>>> flag3),geom.STAsBinary(),convert(varchar(20), id) from region1 WHERE
>>>> geom.STIntersects(Geometry::STGeomFromText('POLYGON((55.4843749962207
>>>> -4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545
>>>> -3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207
>>>> -4.59960928778372))',4326)) = 1
>>>> [Tue Mar 02 12:28:48 2010].394000 msMSSQL2008LayerClose datastatement:
>>>> geom
>>>> from region1 USING UNIQUE id USING SRID=4326
>>>> [Tue Mar 02 12:28:48 2010].394000
>>>>
>>>> msConnPoolRelease(region1,server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>>> Security=false,01E39FC0)
>>>> [Tue Mar 02 12:28:48 2010].394000
>>>>
>>>> msConnPoolClose(server=3.254.254.34;uid=sa;pwd=pwd;database=map;Integrated
>>>> Security=false,01E39FC0)
>>>> [Tue Mar 02 12:28:48 2010].410000 freeLayer(): freeing layer at
>>>> 01E15180.
>>>>
>>>> Thnx
>>>> Afroz
>>>> --
>>>> View this message in context:
>>>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4659685.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
>>>>
>>>
>>>
>>
>
>
> _______________________________________________
> 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/20100306/18126d8e/attachment.htm>
More information about the MapServer-users
mailing list