Howdy,
I’m trying to hook up the latest nightly build of GeoServer 1.6 b3 to ArcSDE 9.2 for SQL Server using the latest available SDE data store from SourceForge. I’m running Tomcat 6.0.14 on Windows XP SP2.
I have placed the necessary files in the GeoServer webapps\geoserver\WEB-INF\lib directory:
- icu4j_3_2.jar
- gt2-arcsde.jar
- jpe92_sdk.jar
- jsde92_sdk.jar
- commons-pool-1.3.jar
When I restart Tomcat I can create a new datastore of type ArcSDE with the usual parameters (5151 port, yadda yadda) and it will let me Submit, Apply, restart Tomcat, and generally act nicely. Unfortunately, every time I try to create a New Featuretype based on an ArcSDE layer it bombs with an Unhandled Exception thrown: class java.lang.NullPointerException message. I can list the layers that I have permission for in sde just fine in the dropdown of available datasources, but clicking Submit on the Create New Feature Type page just fails every single time.
Here’s what the log looks like at failure:
form connection params { port=5151, dbtype=“arcsde”, pool.timeOut=1000, server=“localhost”, instance=“TestData”, pool.maxConnections=2, password=“woolpert”, user=“arcadmin”, pool.minConnections=2}
typeNames : (" TESTDATA.ARCADMIN.ORTHOS", “TESTDATA.ARCADMIN.PARCELS”, “TESTDATA.ARCADMIN.REAL_PROP”, “TESTDATA.ARCADMIN.SMAIN”, “TESTDATA.ARCADMIN.SMANHOLE”, “TESTDATA.ARCADMIN.STRNET”, " TESTDATA.ARCADMIN.ZONING")
log4j:WARN File option not set for appender [geoserverlogfile].
log4j:WARN Are you using FileAppender instead of ConsoleAppender?
18 Oct 17:15:42 INFO [ geoserver.global] - StdOut logging enabled. Log file also output to ‘c:\tomcat6014\webapps\geoserver\data\logs/geoserver.log’
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_giant_polygon:::giant_polygon’ (layer 1/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_poi:::poi’ (layer 2/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘DS_poly_landmarks:::poly_landmarks’ (layer 3/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘DS_tiger_roads:::tiger_roads’ (layer 4/14)
18 Oct 17:15:43 INFO [geoserver.global ] - Loading feature type ‘sfArchsites:::archsites’ (layer 5/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfBugsites:::bugsites’ (layer 6/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfRestricted:::restricted’ (layer 7/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfRoads:::roads’ (layer 8/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfStreams:::streams’ (layer 9/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘states_shapefile:::states’ (layer 10/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘tasmania_cities:::tasmania_cities’ (layer 11/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘tasmania_roads:::tasmania_roads’ (layer 12/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘tasmania_state_boundaries:::tasmania_state_boundaries’ (layer 13/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘tasmania_water_bodies:::tasmania_water_bodies’ (layer 14/14)
log4j:WARN File option not set for appender [geoserverlogfile].
log4j:WARN Are you using FileAppender instead of ConsoleAppender?
18 Oct 17:15:43 INFO [geoserver.global] - StdOut logging enabled. Log file also output to ‘c:\tomcat6014\webapps\geoserver\data\logs/geoserver.log’
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_giant_polygon:::giant_polygon’ (layer 1/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_poi:::poi’ (layer 2/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_poly_landmarks:::poly_landmarks’ (layer 3/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘DS_tiger_roads:::tiger_roads’ (layer 4/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfArchsites:::archsites’ (layer 5/14)
18 Oct 17:15:43 INFO [ geoserver.global] - Loading feature type ‘sfBugsites:::bugsites’ (layer 6/14)
18 Oct 17:15:43 INFO [geoserver.global ] - Loading feature type ‘sfRestricted:::restricted’ (layer 7/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfRoads:::roads’ (layer 8/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘sfStreams:::streams’ (layer 9/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘states_shapefile:::states’ (layer 10/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘tasmania_cities:::tasmania_cities’ (layer 11/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘tasmania_roads:::tasmania_roads’ (layer 12/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘tasmania_state_boundaries:::tasmania_state_boundaries’ (layer 13/14)
18 Oct 17:15:43 INFO [geoserver.global] - Loading feature type ‘tasmania_water_bodies:::tasmania_water_bodies’ (layer 14/14)
18 Oct 17:15:59 WARN [data.arcsde] - Figured Row-ID Column named ‘OBJECTID’ for table TESTDATA.ARCADMIN.PARCELS
18 Oct 17:15:59 WARN [action.RequestProcessor] - Unhandled Exception thrown: class java.lang.NullPointerException
I’m trying to generate support for GeoServer in my consulting company but this is a show stopper.Any ideas?
Cheers,
Dylan