[Geoserver-users] Problem with the SDE datastore

Hello,

I installed the last version of GeoServer (the 1.6.0) and I wanted to try
the SDE datastore.

The installation of the extension works fine and I am able to connect to my
SDE database (SDE 9.1 for Oracle 10g, on windows).

But when I try to define a new feature type based on one of my SDE layer,
geoserver raises an exception:

13 févr. 09:43:30 ERROR [[/geoserver].[action]] - "Servlet.service()" pour
la servlet action a généré une exception
java.lang.NoSuchFieldError: NONE
  at
org.geotools.data.arcsde.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.ja
va:418)
  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(DataFeature
TypesNewAction.java:84)
  at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.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(Application
FilterChain.java:269)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterE
ncodingFilter.java:108)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:264)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:110)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:217)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:229)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
  at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
834)
  at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:640)
  at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
  at java.lang.Thread.run(Thread.java:619)

And I must restart my Tomcat container to enable GeoServer to access my SDE
datastore again.

Can anyone help me with this problem ?

Alexandre Gacon

Alexandre,

The most likely problem here is that there is an unsupported column-type
in your SDE table. For example, we don't support the "unicode" column
types completely yet. That's "NSTRING" (instead of STRING) usually.

Also, we don't support XML or BLOB column types, and they will tend to
cause your geoserver to throw this kind of error.

If you can share with us the result of an "sdetable -o describe -t
<TABLE-NAME>" command, we can probably confirm this hypothesis...or
start looking for other bugs!

--saul

On Wed, 2008-02-13 at 10:46 +0100, Alexandre Gacon wrote:

Hello,

I installed the last version of GeoServer (the 1.6.0) and I wanted to try
the SDE datastore.

The installation of the extension works fine and I am able to connect to my
SDE database (SDE 9.1 for Oracle 10g, on windows).

But when I try to define a new feature type based on one of my SDE layer,
geoserver raises an exception:

13 févr. 09:43:30 ERROR [[/geoserver].[action]] - "Servlet.service()" pour
la servlet action a généré une exception
java.lang.NoSuchFieldError: NONE
  at
org.geotools.data.arcsde.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.ja
va:418)
  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(DataFeature
TypesNewAction.java:84)
  at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.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(Application
FilterChain.java:269)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterE
ncodingFilter.java:108)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:264)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:110)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:217)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:229)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
  at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
834)
  at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:640)
  at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
  at java.lang.Thread.run(Thread.java:619)

And I must restart my Tomcat container to enable GeoServer to access my SDE
datastore again.

Can anyone help me with this problem ?

Alexandre Gacon

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users