[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server
Paul james
pauljame at gmail.com
Mon Mar 8 09:25:16 EST 2010
Now It´s working Tamas...
I´ll test more later...
Thanks !
Paul
On Sat, Mar 6, 2010 at 6:56 PM, Tamas Szekeres <szekerest at gmail.com> wrote:
> 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/20100308/28bb2cce/attachment-0001.html
More information about the mapserver-users
mailing list