[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server

[Tamas Szekeres]

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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100303/3f9f87e6/attachment.htm>