I'm new to GeoServer but I have been able to get it up and running and connecting to my SQL Server 2008 R2. I am working through the Book "GeoServer Beginner's Guide" from Packt Publishing. I figured out how to get the U.S. Census Counties shape file in to SQL Server and it shows as spatial objects in SQL management studio so I think the data is OK.
My first problem is that when I ask it to compute the bounding box from data I get the following: /Oops, something went wrong... Sorry, something unexpected happened on the server. Here's an error report you can include in a JIRA bug report about this issue: java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:508)/ Ok so I go ahead and enter the bounding box manually and and I am able to publish the layer. However, now when I preview the layer it is blank and when I click in the map area I get the following: /Internal error occurred java.io.IOException null A .NET Framework error occurred during execution of user-defined routine or aggregate "geometry": System.ArgumentException: 24144: This operation cannot be completed because the instance is not valid. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a geometry instance to shift slightly. System.ArgumentException: at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid() at Microsoft.SqlServer.Types.SqlGeometry.STIntersects(SqlGeometry other) at Microsoft.SqlServer.Types.SqlGeometry.Filter(SqlGeometry other) . / Apparently this was a problem back in 2010 with version 2.0.2. I am running version 2.3.2. on windows server 2008 R2 and SQL Server 2008 R2 I don't want to post a JIRA bug report, because I'm to new of a user to tell if it is a bug or something I'm doing wrong. Thanks, Mark -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Problem-tp5060024.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
