Re: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot create new feature type

[Gabriel R. <gr...@op...>]

Hi Quincyme,

no its not related to your table, its a bug and I found the source, thanks for 
the logs.

Btw, your table does not have a primary key, nor an sde managed rowid nor a 
user managed row id, which is dangerous, since the only way we have to get a 
feature id out of it is by using the SHAPE identifier, which may be null if 
the table allows for null shapes. Also, it'll be read only.
You should create a rowid field for it, either managed by arcsde or by the 
user. I guess you can easily do that with arccatlog or some command line 
utility.

I'm gonna fix and send you a replacement jar asap.

Cheers,

Gabriel

On Tuesday 19 August 2008 09:56:46 am q luong wrote:
> sorry wrong log. It should be this one
>
> ----------------------------------------
>
> > From: lu...@ho...
> > To: gr...@op...
> > CC: lu...@ho...
> > Subject: RE: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot create
> > new  feature type Date: Tue, 19 Aug 2008 12:43:24 +0000
> >
> >
> >
> >
> > Hi Gabriel,
> >
> > I've enclosed the log file as requested.
> >
> > The GUI says
> >
> > Obtaining FID strategy for SDE_BODC_SPATIAL_OBJECTS[SDE error -110]
> > [Error desc=THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.]
> >
> > My arcsde table's spatial object field is called 'SHAPE' and is in
> > standard EPSG:4326. I viewed it using an ESRI ArcExplorer 9.2.0 java
> > version (free download/use) and the features display fine.
> >
> > I'am not sure if there's perhaps something wrong with my arcsde table?
> > but hopefully things will become clearer.
> >
> > Many thanks and look forward to reply
> > Quincyme.
> >
> >
> >
> >
> >
> >
> > ----------------------------------------
> >
> > > From: gr...@op...
> > > To: lu...@ho...
> > > Subject: Re: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot
> > > create new  feature type Date: Mon, 18 Aug 2008 13:03:02 -0300
> > >
> > > Hi again Quincyme,
> > >
> > > Please replace the geotools arcsde jar by the attached one in
> > > <geoserver>/WEB-INF/lib and restart geoserver, then set the logging
> > > profile to GEOTOOLS_DEVELOPER_LOGGING and apply the configuration.
> > >
> > > This should give us a better exception message and more logging, then
> > > send me the output, hopefully the full <geoserver>/logs/geosever.log
> > > file
> > >
> > > Cheers,
> > >
> > > Gabriel
> > >
> > > On Thursday 14 August 2008 08:17:35 am quincyme wrote:
> > > > Can anyone help or have experienced the same problem?
> > > >
> > > > Installed GeoServer 1.7.0-beta2 and the ArcSDE extension
> > > > gt-arcsde-2.5-SNAPSHOT.jar
> > > > Added ArcSDE libraries jsde_sdk-9.1.jar, jsde_sdkres-9.1.jar,
> > > > jpe_sdk-9.1.jar to PATH.
> > > > Startup geoserver and use the User interface to create ArcSDE
> > > > datastore and then 'Create new FeatureType'
> > > >
> > > > A list of ArcSDE tables are correctly displayed but when I click on
> > > > button 'New' it just says
> > > >
> > > > 'Obtaining FID strategy for SDE_BODC_SPATIAL_OBJECTS'
> > > >
> > > > I checked on the console ...
> > > >
> > > > org.geotools.data.DataSourceException: Obtaining FID strategy for
> > > > SDE_BODC_SPATIAL_OBJECTS:
> > > >         at
> > > > org.geotools.arcsde.data.FIDReader.getFidReader(FIDReader.java:165)
> > > >         at
> > > > org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java
> > > >:273) at
> > > > org.geotools.arcsde.data.ArcSDEDataStore.getFeatureTypeInfo(ArcSDEDat
> > > >aStore .java:626) at
> > > > org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStore.ja
> > > >va:170 ) at
> > > > org.geoserver.catalog.util.LegacyCatalogImporter.readFeatureType(Lega
> > > >cyCata logImporter.java:441) at
> > > > org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCatalogI
> > > >mporte r.java:154) at
> > > > org.geoserver.config.GeoServerLoader.initialize(GeoServerLoader.java:
> > > >84) at
> > > > org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(
> > > >GeoSer verLoader.java:67)
> > > >
> > > > Have I missed something or not carrying out the correct procedure?
> > > >
> > > > My operating system is Linux, with Oracle 8.1.7, ArcSDE 9.1, java
> > > > version "1.6.0_10-beta"
> > > >
> > > > Any help or hints would be appreciated. Thanks
> > > > Quincyme
> >
> > _________________________________________________________________
> > Get Hotmail on your mobile from Vodafone
> > http://clk.atdmt.com/UKM/go/107571435/direct/01/
>
> _________________________________________________________________
> Make a mini you on Windows Live Messenger!
> http://clk.atdmt.com/UKM/go/107571437/direct/01/