Nobody has any experience with geoserver + sql server?
On Fri, Sep 7, 2012 at 9:16 AM, Casper Span <i...@spatially-oriented.com>wrote:
> 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
>
>
>
--
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
