com.microsoft.sqlserver.jdbc.SQLServerException wrong query string on wms GetMap request
----------------------------------------------------------------------------------------
Key: GEOS-3939
URL: http://jira.codehaus.org/browse/GEOS-3939
Project: GeoServer
Issue Type: Bug
Components: SQLServer, WMS
Affects Versions: 2.0.1
Environment: ms windows server 2003
Java 1.6 update 20
Geoserver 2.0.1
Reporter: Lazarev Eugene
Assignee: Andrea Aime
Priority: Blocker
Attachments: featuretype.xml, layer.xml
when configure layer resource form SqlDataSource on MS SQL Server 2008
and trying request wms map i had an error
com.microsoft.sqlserver.jdbc.SQLServerException: 'geometry::STGeomFromText' failed because parameter 2 is not allowed to be null.
in query
SELECT CAST("Object".STSrid as VARCHAR) + ':' + "Object".STAsText() as "Object" FROM "opengis"."NT_Building" WHERE "Object".Filter(geometry::STGeomFromText('POLYGON ((15935.3908515625 11623.6635039065, 15935.3908515625 35460.0304960935, 41197.0251484375 35460.0304960935, 41197.0251484375 11623.6635039065, 15935.3908515625 11623.6635039065))', null)) = 1
if i change null to my current crs 4284
there are data
4284:POLYGON ((23799.644723828591 ... 21150.097891742826))
4284:POLYGON ((23994.068768901445 21...72.73008319853))
...
that data seems that crs is correct and present in DB
over INTERNET i found also problem without solution
http://permalink.gmane.org/gmane.comp.gis.geoserver.user/20221
this bug stop our developing because our datacenter on SQL Server 2008 and we can't use an other
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira