Hey together,
I got an error using the MS SQL Server Plugin.
The geoserver version is 2.0.2.
The JDBC Drivwer is version*3.0.*
I got a connection to my SQL Server and published a layer.
The SRS of the layer is recognized automatically, so I added it manually.
There is no problem downloading the layer as GML or shapefile via
geoserver, but
when I try to access the layer via WMS I got following error message in
the Log-file:
Caused by: java.lang.RuntimeException:
com.microsoft.sqlserver.jdbc.SQLServerException: Fehler bei
'geometry::STGeomFromText', weil der 2-Parameter nicht NULL sein darf.
at
org.geotools.jdbc.JDBCFeatureReader.hasNext(JDBCFeatureReader.java:230)
at
org.geotools.data.store.ContentFeatureCollection$WrappingFeatureIterator.hasNext(ContentFeatureCollection.java:187)
at
org.geotools.data.crs.ForceCoordinateSystemIterator.hasNext(ForceCoordinateSystemIterator.java:142)
at
org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1874)
at
org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1792)
at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:699)
... 55 more
The info "weil der 2-Parameter nicht NULL sein darf" in the first line
means "because the second parameter is not allowed to be NULL"!?
I actually don't understand this! "geometry::STGeomFromText" why is the
geometry created from WKT here?
The second parameter of the function would be the srid! So it seams to
me that no srid is found or used.
Thanks for any help in advance!
Till
**
<http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707>
**
<http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707>
--
Johann Heinrich von Thünen-Institut
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
- Institut für Waldökologie und Waldinventuren Eberswalde -
Alfred-Möller-Straße 1
16225 Eberswalde
Deutschland
Telefon/Mailbox: +49 (0)3334 65-331
E-Mail: till.kirch...@vti.bund.de
http://www.vti.bund.de
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
