Hi Till,
There have been a few bug fixes with regard to sql server since 2.0.2. I
suggest you try out the latest nightly build of geoserver and the sql server
extension. If the problem persists can you turn on
GEOTOOLS_DEVELOPER_LOGGING and include the query that is being made against
the database when the WMS query is made. And a subset of your data/schema
would help as well.
As for the use of WKT that is the how the geometries are fetched from the
server. Obviously this is suboptimal in that WKB is a much better format
suited for serialization over the wire, but no one has had the mandate to
make that improvement yet. A patch would be very welcome.
-Justin
On Mon, Nov 8, 2010 at 7:22 AM, Till Kirchner <till.kirch...@vti.bund.de>wrote:
> 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.dehttp://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
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
