[Geoserver-users] ArcSDE DataStore Problems

GeoServer GeoServer User
1

Hi list,

Im having a problem using ArcSDE as datastore. The first step, adding the ArcSDE as a datastore seems to work fine. I have a SDE-datastore available now in the DataStore ID dropdown menu.

But when I try to add a new feauture type, the features from the sde-datastore are showed me fine, but when I select on of them and click on New to generate a new feature i get and exception like this

The following exception was thrown:
java.lang.NullPointerException

And in tomcat logs appears the next:

04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEDataStoreFactory isAvailable
MÁS FINA: com.esri.sde.sdk.client.SeConnection is in place.
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEDataStoreFactory isAvailable
MÁS FINA: com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEAdapter createAttributeTypes
ADVERTENCIA: Figured Row-ID Column named ‘OBJECTID’ for table SDE.ANTENAS
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEAdapter parseCRS
INFO: About to parse CRS for layer ANTENAS: PROJCS[“ED_1950_UTM_Zone_30N”,GEOGCS[“GCS_European_1950”,DATUM[“D_European_1950”,SPHEROID[“International_1924”, 6378388.0,297.0]],PRIMEM[“Greenwich”,0.0],UNIT[“Degree”,0.0174532925199433]],PROJECTION[“Transverse_Mercator”],PARAMETER[“False_Easting”,500000.0],PARAMETER[“False_Northing”, 0.0],PARAMETER[“Central_Meridian”,-3.0],PARAMETER[“Scale_Factor”,0.9996],PARAMETER[“Latitude_Of_Origin”,0.0],UNIT[“Meter”,1.0]]
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEAdapter parseCRS
INFO: Se CRS envelope: (-730491.0,3038322.0,1468533.0000000005,5237346.0)
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEAdapter parseCRS
FINA: ArcSDE CRS correctly parsed from layer ANTENAS
04-may-2007 14:19:45 org.geotools.data.arcsde.ArcSDEAdapter createAttributeTypes
FINA: Using arcsde 9 methods
04-may-2007 14:19:45 org.apache.struts.action.RequestProcessor processException
ADVERTENCIA: Unhandled Exception thrown: class java.lang.NullPointerException

04-may-2007 14:19:45 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() para servlet action lanzó excepción
java.lang.NullPointerException
at java.lang.Class.isAssignableFrom (Native Method)
at org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:114)
at org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java :78)
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:83)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
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:709)
at javax.servlet.http.HttpServlet.service (HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :173)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java :80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)

Someone knows what’s causing this problem?

Thanks

2

José Ramón López ha scritto:

Hi list,
Im having a problem using *ArcSDE* as datastore. The first step, adding the *ArcSDE* as a datastore seems to work fine. I have a SDE-datastore available now in the DataStore ID dropdown menu.
But when I try to add a new feauture type, the features from the sde-datastore are showed me fine, but when I select on of them and click on New to generate a new feature i get and exception like this

Which version of Geoserver are you using? Can you describe which
type are the attributes of the feature type you're trying to add?
Cheers
Andrea

3

José Ramón López ha scritto:

Im using Geoserver 1.4.1 and this is the description:

OBJECTID number
COD_ENT varchar2
TIPO_LIN number
SHAPE_LENG number
TIPO varchar2
SHAPE SDO_Geometry
SE_ANNO_CAD_DATA Blob

Please keep geoserver-users posted since I'm not the ArcSDE
expert here (Saul and Gabriel are).

Anyways, I'd suggest to try out Geoserver 1.5.0, it should
have an improved ArcSDE datastore compared to the old one
shipped along with 1.4.1.

Cheers
Andrea

4

José Ramón López ha scritto:

I tried the same with geoserver 1.5 and i had the same problems.

Thanks for the information. Let's hope Saul or Gabriel have
some ideas about the issue.
Cheers
Andrea

5

Jose,

Just caught your email, can you tell me about the ArcSDE layer a bit more?

In more detail: what are the SDE datatypes for each column. Oracle's datatype (for example) is "varchar2" but SDE uses 'SE_STRING' or 'String'.

You can find the datatypes for each column in ArcCatalog, or (much better!) by using 'sdetable', the ArcSDE command-line utility.

My guess is that your column SE_ANNO... is a special type of column and we don't handle it very well yet. Possibly an SDE_ANNO column, or possibly you have an SE_NSTRING in there which wasn't handled till recently.

I actually just fixed a bug in this a few days ago, so there's a fix which wolud give you a MUCH better error message but it won't be available till 1.5.1 or 1.6.x

--saul

________________________________

From: geoserver-users-bounces@lists.sourceforge.net on behalf of Andrea Aime
Sent: Fri 5/4/2007 9:09 AM
To: José Ramón López
Cc: geoserver users
Subject: Re: [Geoserver-users] ArcSDE DataStore Problems

José Ramón López ha scritto:

I tried the same with geoserver 1.5 and i had the same problems.

Thanks for the information. Let's hope Saul or Gabriel have
some ideas about the issue.
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

6

Hi list again.

I have solved the problems. The problem was the SDE_ANNO_CAD_DATA field. I deleted this field and then load the layer through ArcSDE in Geoserver and it is showed me correctly, but now im getting problems with same filds. I cant get info about se_string fields.

This is one example of one of the layers, executing the command sdetable.

ArcSDE 9.1 Oracle9i Build 1269 Thu Mar 3 18:54:58 PST 2005
Attribute Administration Utility

Table aforos:
Column name Attribute type Null? Length,DPs RowID Column?

OBJECTID SE_INT32 NOT NULL 10 SDE Set
CODPTO SE_STRING NULL 50
NOMPTO SE_STRING NULL 254
UTM30_X SE_FLOAT64 NULL 38,8
UTM30_Y SE_FLOAT64 NULL 38,8
ALTITUD SE_FLOAT64 NULL 38,8
CODRED SE_STRING NULL 8
HOJA SE_FLOAT64 NULL 38,8
PER SE_FLOAT64 NULL 38,8
SUP SE_FLOAT64 NULL 38,8
UH2 SE_FLOAT64 NULL 38,8
VOL SE_FLOAT64 NULL 38,8
XUTM_RRHH SE_FLOAT64 NULL 38,8
YUTM_RRHH SE_FLOAT64 NULL 38,8
INICIO SE_STRING NULL 50
NATURALE SE_STRING NULL 20
PER_CAM_DT SE_STRING NULL 50
PER_CAM_O SE_STRING NULL 50
PER_MIN_O SE_STRING NULL 50
PROP SE_STRING NULL 50
PUNTO SE_STRING NULL 50
RIO SE_STRING NULL 50
SISACUI SE_STRING NULL 50
UH SE_STRING NULL 50
UTILAGUA SE_STRING NULL 50
SHAPE SE_SHAPE NULL 0
SE_ANNO_CAD_DATA SE_BLOB NULL 0

In Oracle SE_STRING fields are called VCHAR2.

Thanks again for all

2007/5/8, José Ramón López <joseramonlopez@…84…>:

2007/5/7, Farber, Saul (ENV) <Saul.Farber@anonymised.com>:

Jose,

Just caught your email, can you tell me about the ArcSDE layer a bit more?

In more detail: what are the SDE datatypes for each column. Oracle’s datatype (for example) is “varchar2” but SDE uses ‘SE_STRING’ or ‘String’.

You can find the datatypes for each column in ArcCatalog, or (much better!) by using ‘sdetable’, the ArcSDE command-line utility.

Table antenas:
Column name Attribute type Null? Length,DPs RowID Column?

OBJECTID SE_INT32 NOT NULL 10 SDE Set
NOMBRE SE_STRING NOT NULL 48
COD_ENT SE_STRING NOT NULL 4
SHAPE SE_SHAPE NULL 0
SE_ANNO_CAD_DATA SE_BLOB NULL 0

My guess is that your column SE_ANNO… is a special type of column and we don’t handle it very well yet. Possibly an SDE_ANNO column, or possibly you have an SE_NSTRING in there which wasn’t handled till recently.

I thought that the problem was related with SE_ANNO_CAD_DATA field too.
I had copied this table with other name with no se_annon_cad_data and tryint to configure geoserver with this layer through Oracle, but does not work.

Thanks

I actually just fixed a bug in this a few days ago, so there’s a fix which wolud give you a MUCH better error message but it won’t be available till 1.5.1 or 1.6.x

–saul

7

Saul,

I seem to having a similar problem with ArcSDE and SQL Server. I imported
the STATES shapefile that comes with GeoServer into ArcSDE. When I try to
build a FeatureType, I get a java.lang.NullPointerException error (log
attached below).

Do these SDE datatypes look like they might cause a problem?

I am currently running the GeoServer 1.5.x nightly build from 6/21/2007 and
the ArcSDE 9.2 plugin.

- Tyler

C:>sdetable -o describe -t states -i 5153 -s sql1 -D sde_nrcs

ArcSDE 9.2 for SQL Server Build 1137 Mon Mar 5 15:52:01 2007
Attribute Administration Utility
-----------------------------------------------------

Table states:
Column name Attribute type Null? Length,DPs RowID
Column?
-------------------------------------------------------------------------------
OBJECTID SE_INT32 NOT NULL 10 SDE Set
STATE_NAME SE_NSTRING NULL 25
STATE_FIPS SE_NSTRING NULL 2
SUB_REGION SE_NSTRING NULL 7
STATE_ABBR SE_NSTRING NULL 2
LAND_KM SE_FLOAT64 NULL 27,9
WATER_KM SE_FLOAT64 NULL 27,9
PERSONS SE_FLOAT64 NULL 27,9
FAMILIES SE_FLOAT64 NULL 27,9
HOUSHOLD SE_FLOAT64 NULL 27,9
MALE SE_FLOAT64 NULL 27,9
FEMALE SE_FLOAT64 NULL 27,9
WORKERS SE_FLOAT64 NULL 27,9
DRVALONE SE_FLOAT64 NULL 27,9
CARPOOL SE_FLOAT64 NULL 27,9
PUBTRANS SE_FLOAT64 NULL 27,9
EMPLOYED SE_FLOAT64 NULL 27,9
UNEMPLOY SE_FLOAT64 NULL 27,9
SERVICE SE_FLOAT64 NULL 27,9
MANUAL SE_FLOAT64 NULL 27,9
P_MALE SE_FLOAT64 NULL 27,9
P_FEMALE SE_FLOAT64 NULL 27,9
SAMP_POP SE_FLOAT64 NULL 27,9
Shape SE_SHAPE NULL 0

INFO | jvm 1 | 2007/07/02 17:21:05 | 1175543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_MEASUREMENT_SPATIAL_PH
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_MEASUREMENT_SPATIAL_PH:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.DBO.states
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [SEVERE]
org.vfny.geoserver.global.Data - FeatureTypeInfo
sde_nrcs:::sde_nrcs.DBO.states ignored - as DataStore sde_nrcs is
broken:java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:05 | java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:05 | at
java.lang.Class.isAssignableFrom(Native Method)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:113)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:77)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.java:436)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:292)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:214)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.global.Data.loadFeatureTypes(Data.java:537)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.global.Data.load(Data.java:235)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.LoadXMLAction.loadGeoserver(LoadXMLAction.java:121)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.LoadXMLAction.execute(LoadXMLAction.java:66)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.Server.handle(Server.java:269)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:687)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:193)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_GEOSERVER.DBO.T_TESTTABLE
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_TESTTABLE:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-176.696545,17.975734000000003,1970.787102,2165.459381)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.dbo.T_Location
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_LOCATION
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176574 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_MEASUREMENT_SPATIAL_PH
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_MEASUREMENT_SPATIAL_PH:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.DBO.states
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [SEVERE]
org.vfny.geoserver.global.Data - FeatureTypeInfo
sde_nrcs:::sde_nrcs.DBO.states ignored - as DataStore sde_nrcs is
broken:java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:06 | java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:06 | at
java.lang.Class.isAssignableFrom(Native Method)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:113)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:77)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.java:436)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:292)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:214)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.global.Data.loadFeatureTypes(Data.java:537)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.global.Data.load(Data.java:235)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.LoadXMLAction.loadGeoserver(LoadXMLAction.java:123)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.LoadXMLAction.execute(LoadXMLAction.java:66)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.Server.handle(Server.java:269)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:687)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:193)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_GEOSERVER.DBO.T_TESTTABLE
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_TESTTABLE:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-176.696545,17.975734000000003,1970.787102,2165.459381)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.dbo.T_Location
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_LOCATION
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map

sfarber wrote:

Jose,

Just caught your email, can you tell me about the ArcSDE layer a bit more?

In more detail: what are the SDE datatypes for each column. Oracle's
datatype (for example) is "varchar2" but SDE uses 'SE_STRING' or 'String'.

You can find the datatypes for each column in ArcCatalog, or (much
better!) by using 'sdetable', the ArcSDE command-line utility.

My guess is that your column SE_ANNO... is a special type of column and we
don't handle it very well yet. Possibly an SDE_ANNO column, or possibly
you have an SE_NSTRING in there which wasn't handled till recently.

I actually just fixed a bug in this a few days ago, so there's a fix which
wolud give you a MUCH better error message but it won't be available till
1.5.1 or 1.6.x

--saul

________________________________

From: geoserver-users-bounces@lists.sourceforge.net on behalf of Andrea
Aime
Sent: Fri 5/4/2007 9:09 AM
To: José Ramón López
Cc: geoserver users
Subject: Re: [Geoserver-users] ArcSDE DataStore Problems

José Ramón López ha scritto:

I tried the same with geoserver 1.5 and i had the same problems.

Thanks for the information. Let's hope Saul or Gabriel have
some ideas about the issue.
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/ArcSDE-DataStore-Problems-tf3691768.html#a11402599
Sent from the GeoServer - User mailing list archive at Nabble.com.

8

Hmm...that SE_NSTRING might be the culprit, but I thought that I got the NSTRING type into the 2.3.x geotools branch. Let me check real quick...

yep, looks like that's the problem:
http://gtsvn.refractions.net/geotools/branches/2.3.x/plugin/arcsde/datastore/src/org/geotools/arcsde/data/ArcSDEAdapter.java

I think I have that fixed in my local copy of the ArcSDE adapter code...I'll commit the fix right now.

--saul

________________________________

From: geoserver-users-bounces@lists.sourceforge.net on behalf of Tyler Erickson
Sent: Mon 7/2/2007 5:46 PM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ArcSDE DataStore Problems

Saul,

I seem to having a similar problem with ArcSDE and SQL Server. I imported
the STATES shapefile that comes with GeoServer into ArcSDE. When I try to
build a FeatureType, I get a java.lang.NullPointerException error (log
attached below).

Do these SDE datatypes look like they might cause a problem?

I am currently running the GeoServer 1.5.x nightly build from 6/21/2007 and
the ArcSDE 9.2 plugin.

- Tyler

C:>sdetable -o describe -t states -i 5153 -s sql1 -D sde_nrcs

ArcSDE 9.2 for SQL Server Build 1137 Mon Mar 5 15:52:01 2007
Attribute Administration Utility
-----------------------------------------------------

Table states:
Column name Attribute type Null? Length,DPs RowID
Column?
-------------------------------------------------------------------------------
OBJECTID SE_INT32 NOT NULL 10 SDE Set
STATE_NAME SE_NSTRING NULL 25
STATE_FIPS SE_NSTRING NULL 2
SUB_REGION SE_NSTRING NULL 7
STATE_ABBR SE_NSTRING NULL 2
LAND_KM SE_FLOAT64 NULL 27,9
WATER_KM SE_FLOAT64 NULL 27,9
PERSONS SE_FLOAT64 NULL 27,9
FAMILIES SE_FLOAT64 NULL 27,9
HOUSHOLD SE_FLOAT64 NULL 27,9
MALE SE_FLOAT64 NULL 27,9
FEMALE SE_FLOAT64 NULL 27,9
WORKERS SE_FLOAT64 NULL 27,9
DRVALONE SE_FLOAT64 NULL 27,9
CARPOOL SE_FLOAT64 NULL 27,9
PUBTRANS SE_FLOAT64 NULL 27,9
EMPLOYED SE_FLOAT64 NULL 27,9
UNEMPLOY SE_FLOAT64 NULL 27,9
SERVICE SE_FLOAT64 NULL 27,9
MANUAL SE_FLOAT64 NULL 27,9
P_MALE SE_FLOAT64 NULL 27,9
P_FEMALE SE_FLOAT64 NULL 27,9
SAMP_POP SE_FLOAT64 NULL 27,9
Shape SE_SHAPE NULL 0

INFO | jvm 1 | 2007/07/02 17:21:05 | 1175543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_MEASUREMENT_SPATIAL_PH
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_MEASUREMENT_SPATIAL_PH:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175684 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.DBO.states
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [SEVERE]
org.vfny.geoserver.global.Data - FeatureTypeInfo
sde_nrcs:::sde_nrcs.DBO.states ignored - as DataStore sde_nrcs is
broken:java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:05 | java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:05 | at
java.lang.Class.isAssignableFrom(Native Method)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:113)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:77)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.java:436)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:292)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:214)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.global.Data.loadFeatureTypes(Data.java:537)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.global.Data.load(Data.java:235)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.LoadXMLAction.loadGeoserver(LoadXMLAction.java:121)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.LoadXMLAction.execute(LoadXMLAction.java:66)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.Server.handle(Server.java:269)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:687)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:193)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
INFO | jvm 1 | 2007/07/02 17:21:05 | at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
INFO | jvm 1 | 2007/07/02 17:21:05 | 1175902 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_GEOSERVER.DBO.T_TESTTABLE
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_TESTTABLE:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:05 | 1176121 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-176.696545,17.975734000000003,1970.787102,2165.459381)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.dbo.T_Location
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176231 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_LOCATION
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176449 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176574 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_MEASUREMENT_SPATIAL_PH
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_MEASUREMENT_SPATIAL_PH:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176777 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.DBO.states
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [SEVERE]
org.vfny.geoserver.global.Data - FeatureTypeInfo
sde_nrcs:::sde_nrcs.DBO.states ignored - as DataStore sde_nrcs is
broken:java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:06 | java.lang.NullPointerException
INFO | jvm 1 | 2007/07/02 17:21:06 | at
java.lang.Class.isAssignableFrom(Native Method)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:113)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:77)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.java:436)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:292)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:214)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.global.Data.loadFeatureTypes(Data.java:537)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.global.Data.load(Data.java:235)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.LoadXMLAction.loadGeoserver(LoadXMLAction.java:123)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.LoadXMLAction.execute(LoadXMLAction.java:66)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.Server.handle(Server.java:269)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:687)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:193)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
INFO | jvm 1 | 2007/07/02 17:21:06 | at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
INFO | jvm 1 | 2007/07/02 17:21:06 | 1176996 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_GEOSERVER.DBO.T_TESTTABLE
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_TESTTABLE:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177215 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-176.696545,17.975734000000003,1970.787102,2165.459381)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table sde_nrcs.dbo.T_Location
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
T_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177324 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [WARNING]
org.geotools.arcsde.data.ArcSDEAdapter - Figured Row-ID Column named
'OBJECTID' for table SDE_NRCS.DBO.V_LOCATION
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - About to parse CRS for layer
V_LOCATION:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.data.ArcSDEAdapter - Se CRS envelope:
(-180.0,-90.0,180.0000000000001,270.0000000000001)
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map
INFO | jvm 1 | 2007/07/02 17:21:07 | 1177543 [INFO]
org.geotools.arcsde.ArcSDEDataStoreFactory - Checking whether class
org.geotools.arcsde.ArcSDEDataStoreFactory can process this map

sfarber wrote:

Jose,

Just caught your email, can you tell me about the ArcSDE layer a bit more?

In more detail: what are the SDE datatypes for each column. Oracle's
datatype (for example) is "varchar2" but SDE uses 'SE_STRING' or 'String'.

You can find the datatypes for each column in ArcCatalog, or (much
better!) by using 'sdetable', the ArcSDE command-line utility.

My guess is that your column SE_ANNO... is a special type of column and we
don't handle it very well yet. Possibly an SDE_ANNO column, or possibly
you have an SE_NSTRING in there which wasn't handled till recently.

I actually just fixed a bug in this a few days ago, so there's a fix which
wolud give you a MUCH better error message but it won't be available till
1.5.1 or 1.6.x

--saul

________________________________

From: geoserver-users-bounces@lists.sourceforge.net on behalf of Andrea
Aime
Sent: Fri 5/4/2007 9:09 AM
To: José Ramón López
Cc: geoserver users
Subject: Re: [Geoserver-users] ArcSDE DataStore Problems

José Ramón López ha scritto:

I tried the same with geoserver 1.5 and i had the same problems.

Thanks for the information. Let's hope Saul or Gabriel have
some ideas about the issue.
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/ArcSDE-DataStore-Problems-tf3691768.html#a11402599
Sent from the GeoServer - User mailing list archive at Nabble.com.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

9

Saul,

The rebuilt gt2-arcsde.jar seems to have fixed the issue.
The Map Preview is displaying the layer, and the log file seems normal.

Thanks!
- Tyler

sfarber wrote:

Tyler,

Here's a rebuilt (hopefully working) gt2-arcsde.jar file for you.

You'll probably have to rename it to the right name (gt2-arcsde.jar) and
then put it into your geoserver/WEB-INF/lib directory, after removing the
old one.

Let me know if this one works for you!

--saul

________________________________

From: prvs=tyler.erickson=697fbca2f@anonymised.com on behalf of Tyler Erickson
Sent: Tue 7/3/2007 2:12 PM
To: Farber, Saul (EEA)
Subject: Re: ArcSDE DataStore Problems

No problem. I'm still getting the hang of where to get ahold of updates
as they happen...

Unfortunately, I don't know how to do a rebuild. I'm not very
knowledgeable in Java programming, so I've just been using the built jar
files.

- Tyler

--
View this message in context: http://www.nabble.com/ArcSDE-DataStore-Problems-tf3691768.html#a11418370
Sent from the GeoServer - User mailing list archive at Nabble.com.