[Geoserver-users] error when creating FeatureType for SQL Server 2008 datastore

Chan_Keith_LESA_IT · April 21, 2009, 7:31pm

I got exception when creating FeatureType for a SQL Server datastore. My environment is Windows 2003 Server with sp2, SQL Server 2008 ent edition.

I did followings

Download and installed geoserver 1.7.3
download sql server extension and copy gt-jdbc-core-2.5.4.jar, gt-jdbc-core-2.5.4-tests.jar, gt-jdbc-sqlserver-2.5.4.jar to

c:\Program Files\GeoServer 1.7.3\webapps\geoserver\WEB-INF\lib

download Microsoft SQL Server 2005 Driver 1.2 and copy sqljdbc.jar to the same directory as above
download GIS data st99_d00.shp and other files
import the shape data to a database in PostGre server with table name us_states by PostGIS tool
import the shape data to a database in SQL Server 2008 server with table name us_states by a downloaded tool Shape2Sql.exe
create a datastore for the PostGre database
create a datastore for the SQL Server database (I can see the datastore created with its name plus table name when creating FeatureType)
create FeatureType for the PostGre datastore

select Polygon for Styles, enter 4326 for SRS, then click button Generate. It populated values for Long, Lat. Then click Submit, Apply, Save buttons.

Create FeatureType for the SQL Server datastore

I did samething as 9., but when clicking button Generate, it shown error message

GeoServer - Exception

The following exception was thrown:

class java.lang.RuntimeException: java.io.IOException

class java.io.IOException:

class org.opengis.referencing.NoSuchAuthorityCodeException: No code “EPSG:0” from authority “European Petroleum Survey Group” found for object of type “IdentifiedObject”.

Details:

java.lang.RuntimeException: java.io.IOException

at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:439)

at org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:141)

at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:357)

at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:329)

at org.geoserver.feature.FeatureSourceUtils.getBoundingBoxEnvelope(FeatureSourceUtils.java:44)

at org.vfny.geoserver.util.DataStoreUtils.getBoundingBoxEnvelope(DataStoreUtils.java:318)

at org.vfny.geoserver.action.data.TypesEditorAction.executeBBox(TypesEditorAction.java:236)

at org.vfny.geoserver.action.data.TypesEditorAction.execute(TypesEditorAction.java:138)

at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)

at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)