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: luongq@anonymised.com
> To: groldan@anonymised.com
> CC: luongq@anonymised.com
> 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: groldan@anonymised.com
> > To: luongq@anonymised.com
> > 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/
Hey Gabriel,
I'm having the exact same issue trying to move a client to Geoserver 1.7.
Could you please forward me that JAR as well? Or a link to it?
Thanks,
Amr.
Gabriel Roldán wrote:
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: luongq@anonymised.com
To: groldan@anonymised.com
CC: luongq@anonymised.com
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: groldan@anonymised.com
To: luongq@anonymised.com
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/
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Refractions Research
Suite 300 - 1207 Douglas St
Victoria, BC, V8W 2E7, Canada
ph: (250) 383-3022
fax:(250) 383-2140