[Geoserver-users] Problems with ArcSDE

Kathrin_KOHL · January 31, 2008, 3:51pm

HI list,
The ICT team here (successfully) installed the ArcSDE extension for GeoServer. When I open the GeoServer Interface and create a new datastore I can add a ArcSDE datastore. I also made the right setting (I think at least). When I then go to create a new FeatureType I can also choose the data from the ArcSDE database. If I choose one of them and click on the "New" button below I get:
GeoServer - Exception
The following exception was thrown:
/|java.lang.NullPointerException|/
/||/||/||/
/||/If I choose any of the shapefiles which I implemented as well I get to the FeatureType Editor.
Was I supposed to do something in-between that I missed out on?
Below are error messages from the Tomcat 6.0 on which GeoServer is installed. I'm using GeoServer 1.5.4 on Cent OS 5.1.
In the table ITGI_ADM.AD_STATISTICSECTOR the field OBJECTID does exist Data Type is Object ID and it is not empty.
Would be nice if anyone has a suggestion what went wrong.
Kathrin

/||/catalina.out:
SEVERE: Error starting endpoint
java.net.BindException: Address already in use:8080
LifecycleException: service.getName(): "Catalina"; Protocol handler start failed: java.net.BindException: Address already in use:8080
142214 [WARNING] org.geotools.data.arcsde.ArcSDEAdapter - Figured Row-ID Column named 'OBJECTID' for table ITGI_ADM.AD_STATISTICSECTOR
23 Jan 15:52:50 WARN [action.RequestProcessor] - Unhandled Exception thrown: class java.lang.NullPointerException

catalinaDate.log:
SEVERE: Error starting endpoint
java.net.BindException: Address already in use:8080
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:501)
    at org.apache.tomcat.util.net.JIoEndpoint.start(JIoEndpoint.java:515)
    at org.apache.coyote.http11.Http11Protocol.start(Http11Protocol.java:204)
    at org.apache.catalina.connector.Connector.start(Connector.java:1132)
    at org.apache.catalina.core.StandardService.start(StandardService.java:531)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
SEVERE: Catalina.start:
LifecycleException: service.getName(): "Catalina"; Protocol handler start failed: java.net.BindException: Address already in use:8080
at org.apache.catalina.connector.Connector.start(Connector.java:1139)
    at org.apache.catalina.core.StandardService.start(StandardService.java:531)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Jan 23, 2008 3:52:50 PM org.geotools.data.arcsde.ArcSDEAdapter createAttributeTypes
WARNING: Figured Row-ID Column named 'OBJECTID' for table ITGI_ADM.AD_STATISTICSECTOR

localhostDate.log:
Jan 23, 2008 3:52:50 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
at java.lang.Class.isAssignableFrom(Native Method)
    at org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:113)
    at org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:77)
    at org.geotools.data.arcsde.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.java:425)
    at org.geotools.data.arcsde.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:287)
    at org.geotools.data.arcsde.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:202)
    at org.vfny.geoserver.action.data.DataFeatureTypesNewAction.execute(DataFeatureTypesNewAction.java:70)
    at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
    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:710)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:619)

Gabriel_Roldan2 · January 31, 2008, 4:30pm

Hi Kathrin,

ok, it makes sense you're getting this exception as I'm quite sure the error
is just the same than for the <http://jira.codehaus.org/browse/GEOT-1687>
issue.
Actually I don't think its fixed for any released version though the fix has
been introduced into geotools last week.
What you can do is to download geoserver 1.6-RC2, install the arcsde extension
for it, and then replace the arcsde jar with the one I'm going to send you
off-list. Or rather you can choose to build the geotools-2.4 and
geoserver-1.6 branches yourself, let me know in any case.

Cheers,
Gabriel

On Thursday 31 January 2008 04:51:05 pm Kathrin KÖHL wrote:

HI list,
The ICT team here (successfully) installed the ArcSDE extension for
GeoServer. When I open the GeoServer Interface and create a new
datastore I can add a ArcSDE datastore. I also made the right setting (I
think at least). When I then go to create a new FeatureType I can also
choose the data from the ArcSDE database. If I choose one of them and
click on the "New" button below I get:
GeoServer - Exception
The following exception was thrown:
/|java.lang.NullPointerException|/
...

Kathrin_KOHL · February 5, 2008, 3:06pm

Hi Gabriel,
we did install GeoServer 1.6.0-RC2 but it's still not working with SDE. Even after replacing the jar. I get the same error message at the same time again (when I want to create a FeatureTyp). Then we installed GeoServer 1.6-RC3 and I can connect to Arc SDE and creating FeatureTyp and everything (without replacing the jar) but now I can't see any data anymore not even the data that comes with GeoServer. Then they changed some java variable so that some temp file (?) is bigger now. I'm not quite sure but at least now it does work with GeoServer 1.6-RC3. If the server wouldn't be so slow... Thanks for the help anyway.
I noticed a different behavior of the GS surface with the FeatureType if I create a new one and than want to make a new style I can apply it but then it's not in the list to choose and the data is not displayed in the way I choose. I helped myself by creating the SLD files myself and creating a new style than applying that on the FeatureType interface. I on't know if anybody else realized it or if it's working everywhere else.
I also wanted to install the Arcmap2sld extension for ArcMap but I didn't succeed yet.
Thanks again
Kathrin**

Gabriel Roldán wrote:

Hi Kathrin,

ok, it makes sense you're getting this exception as I'm quite sure the error is just the same than for the <http://jira.codehaus.org/browse/GEOT-1687> issue. Actually I don't think its fixed for any released version though the fix has been introduced into geotools last week.
What you can do is to download geoserver 1.6-RC2, install the arcsde extension for it, and then replace the arcsde jar with the one I'm going to send you off-list. Or rather you can choose to build the geotools-2.4 and geoserver-1.6 branches yourself, let me know in any case.

Cheers,
Gabriel

On Thursday 31 January 2008 04:51:05 pm Kathrin KÖHL wrote:

HI list,
The ICT team here (successfully) installed the ArcSDE extension for
GeoServer. When I open the GeoServer Interface and create a new
datastore I can add a ArcSDE datastore. I also made the right setting (I
think at least). When I then go to create a new FeatureType I can also
choose the data from the ArcSDE database. If I choose one of them and
click on the "New" button below I get:
GeoServer - Exception
The following exception was thrown:
/|java.lang.NullPointerException|/
...