-----Message d'origine-----
De : Alexandre Gacon [mailto:alexandre.gacon@anonymised.com]
Envoyé : jeudi 14 février 2008 15:39
À : 'Saul Farber'
Objet : RE: [Geoserver-users] Problem with the SDE datastore
Hi,
Here is the result of the sdetable command on one of my table:
ArcSDE 9.1 Oracle10g Build 392 Thu Nov 2 15:42:12 PST 2006
Attribute Administration Utility
-----------------------------------------------------
Table vecteur.vecteur_streets_new:
Column name Attribute type Null? Length,DPs RowID
Colum
----------------------------------------------------------------------------
-
OBJECTID SE_INT32 NOT NULL 10 SDE Set
ADDR_ST SE_STRING NULL 5
ADDR_SN SE_STRING NULL 50
ADDR_K1 SE_STRING NULL 28
ADDR_K1_1 SE_STRING NULL 28
ADDR_ST_1 SE_STRING NULL 5
ADDR_SN_1 SE_STRING NULL 50
LINK_ID SE_INT32 NULL 10
ST_NAME SE_STRING NULL 80
FEAT_ID SE_INT32 NULL 10
ST_LANGCD SE_STRING NULL 3
NUM_STNMES SE_INT16 NULL 2
ST_NM_PREF SE_STRING NULL 2
ST_TYP_BEF SE_STRING NULL 30
ST_NM_BASE SE_STRING NULL 35
ST_NM_SUFF SE_STRING NULL 2
ST_TYP_AFT SE_STRING NULL 30
ST_TYP_ATT SE_STRING NULL 1
ADDR_TYPE SE_STRING NULL 1
L_REFADDR SE_STRING NULL 10
L_NREFADDR SE_STRING NULL 10
L_ADDRSCH SE_STRING NULL 1
L_ADDRFORM SE_STRING NULL 1
R_REFADDR SE_STRING NULL 10
R_NREFADDR SE_STRING NULL 10
R_ADDRSCH SE_STRING NULL 1
R_ADDRFORM SE_STRING NULL 1
REF_IN_ID SE_INT32 NULL 10
NREF_IN_ID SE_INT32 NULL 10
N_SHAPEPNT SE_INT32 NULL 5
FUNC_CLASS SE_STRING NULL 1
SPEED_CAT SE_STRING NULL 1
SPEED_LIM SE_INT32 NULL 5
TO_LANES SE_INT16 NULL 2
FROM_LANES SE_INT16 NULL 2
ENH_GEOM SE_STRING NULL 1
LANE_CAT SE_STRING NULL 1
DIVIDER SE_STRING NULL 1
DIR_TRAVEL SE_STRING NULL 1
L_AREA_ID SE_INT32 NULL 10
R_AREA_ID SE_INT32 NULL 10
L_POSTCODE SE_STRING NULL 11
R_POSTCODE SE_STRING NULL 11
L_NUMZONES SE_INT16 NULL 2
R_NUMZONES SE_INT16 NULL 2
NUM_AD_RNG SE_INT16 NULL 2
AR_AUTO SE_STRING NULL 1
AR_BUS SE_STRING NULL 1
AR_TAXIS SE_STRING NULL 1
AR_CARPOOL SE_STRING NULL 1
AR_PEDEST SE_STRING NULL 1
AR_TRUCKS SE_STRING NULL 1
AR_TRAFF SE_STRING NULL 1
AR_DELIV SE_STRING NULL 1
AR_EMERVEH SE_STRING NULL 1
PAVED SE_STRING NULL 1
PRIVATE SE_STRING NULL 1
FRONTAGE SE_STRING NULL 1
BRIDGE SE_STRING NULL 1
TUNNEL SE_STRING NULL 1
RAMP SE_STRING NULL 1
TOLLWAY SE_STRING NULL 1
POIACCESS SE_STRING NULL 1
CONTRACC SE_STRING NULL 1
ROUNDABOUT SE_STRING NULL 1
INTERINTER SE_STRING NULL 1
UNDEFTRAFF SE_STRING NULL 1
FERRY_TYPE SE_STRING NULL 1
MULTIDIGIT SE_STRING NULL 1
MAXATTR SE_STRING NULL 1
SPECTRFIG SE_STRING NULL 1
INDESCRIB SE_STRING NULL 1
MANOEUVRE SE_STRING NULL 1
DIVIDERLEG SE_STRING NULL 1
INPROCDATA SE_STRING NULL 1
FULL_GEOM SE_STRING NULL 1
URBAN SE_STRING NULL 1
ROUTE_TYPE SE_STRING NULL 1
DIRONSIGN SE_STRING NULL 1
EXPLICATBL SE_STRING NULL 1
NAMEONRDSN SE_STRING NULL 1
POSTALNAME SE_STRING NULL 1
STALENAME SE_STRING NULL 1
VANITYNAME SE_STRING NULL 1
JUNCTIONNM SE_STRING NULL 1
EXITNAME SE_STRING NULL 1
L_INSEE SE_STRING NULL 5
R_INSEE SE_STRING NULL 5
L_CITY SE_STRING NULL 80
R_CITY SE_STRING NULL 80
L_POSTCODE_CITY SE_STRING NULL 100
R_POSTCODE_CITY SE_STRING NULL 100
ST_NAME_2 SE_STRING NULL 80
SHAPE SE_SHAPE NULL 0
The underlying database is Oracle 10g, the character set is ISO-8859.
Alexandre
-----Message d'origine-----
De : geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] De la part de Saul
Farber Envoyé : mercredi 13 février 2008 18:14 À : geoserver-users Objet :
Re: [Geoserver-users] Problem with the SDE datastore
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(ArcSDEAdap
ter.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(DataF
eature
TypesNewAction.java:84)
at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at
org.apache.struts.action.RequestProcessor.processActionPerform(Request
Proces
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(Appli
cation
FilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lterCh
ain.java:188)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetChar
acterE
ncodingFilter.java:108)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
cation
FilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lterCh
ain.java:188)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(Filte
rSecur
ityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Fil
terSec
urityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTran
slatio
nFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilt
er(Ano
nymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Re
member
MeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFi
lter(S
ecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcess
ingFil
ter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
ainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter
(HttpS
essionContextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Fi
lterCh
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(Appli
cation
FilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
lterCh
ain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
lve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
lve.ja
va:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
va:127
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
va:117
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
e.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.pro
cess(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
-------------------------------------------------------------------------
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