Hi List,
Just a quick question, I'm not particularly sure if this is a geoserver or
SQL Server (or JDBC driver) issue, but as I have to start my search
somewhere, I might as well do it here. :-)
I have a SQL Server 2008 installation, with some layers in it. One of them
happens to have some rows, but all records have a NULL as geometry value. I
will call this layer A.
I have Geoserver 2.1 with a store pointing at my SQL Server and I created
some layers there. Creating is all working.
Ofcourse, on layer A I cannot compute bounding box from data, so I filled
in the entire scope of the RD (EPSG:28992) coordinate system and translated
it to WGS84. No problems there either.
Now, I go to the layer preview and I get a nice ServiceException:
Rendering process failed
com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error
occurred during execution of user-defined routine or aggregate
"geometry":
System.FormatException: 24100: The spatial reference identifier (SRID) is
not valid. SRIDs must be between 0 and 999999.
System.FormatException:
bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid)
bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid)
bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type,
Int32 srid)
bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType
type, SqlChars text, Int32 srid)
.
A .NET Framework error occurred during execution of user-defined routine or
aggregate "geometry":
System.FormatException: 24100: The spatial reference identifier (SRID) is
not valid. SRIDs must be between 0 and 999999.
System.FormatException:
bij Microsoft.SqlServer.Types.GeometryValidator.ValidateSrid(Int32 srid)
bij Microsoft.SqlServer.Types.ForwardingGeoDataSink.SetSrid(Int32 srid)
bij Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type,
Int32 srid)
bij Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType
type, SqlChars text, Int32 srid)
Is there a way to trick either SQL Server, the JDBC driver or Geoserver to
just return an empty image when the layer contains no geometries?
Regards,
Casper Span
--
Casper Span
T: @Span_Droid <https://twitter.com/#%21/Span_Droid>
W: http://www.spatially-oriented.com
M: i...@spatially-oriented.com
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
