com.microsoft.sqlserver.jdbc.SQLServerException wrong query string on wms
GetMap request
----------------------------------------------------------------------------------------
Key: GEOT-3207
URL: http://jira.codehaus.org/browse/GEOT-3207
Project: GeoTools
Issue Type: Bug
Components: data sqlserver
Affects Versions: 2.6.4
Environment: ms windows server 2003
Java 1.6 update 20
Reporter: Lazarev Eugene
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
{code:sql}
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
{code}
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 data 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
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
