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

Hi Quincyme,

forwarding the good news to geoserver-users.

Indeed the ArcSDE extension got a major refurbish and the way it handles the
connections is way more stable and pretty now.

I'm glad you're finding it useful, please keep posting about any other problem
you find.

best regards,

Gabriel
On Thursday 21 August 2008 04:17:57 am q luong wrote:

Hi Gabrie,Amr,

I've tested out your latest gt-arcsde-2.5-SNAPSHOT.jar for
geoserver-1.7.0-beta2 and I'am happy to say the bug GEOT-1954 appears to
have been fixed. Also magically the ArcSDE connection pooling seems to have
stabilized and I no longer un-expectedly run out of connections as was the
case in earlier versions of geoserver.

Thanks very much for this! Geoserver works like a treat for now.

Keep up the good work!

best regards
Quincyme.

> From: groldan@anonymised.com
> To: aalam@anonymised.com
> Subject: Re: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot create
> new feature type Date: Wed, 20 Aug 2008 21:54:06 -0300
> CC: luongq@anonymised.com
>
> Hi Quincyme, Amr,
>
> please try out the attached jar. The issue at hand was
> http://jira.codehaus.org/browse/GEOT-1954 which I fixed today.
> Also please be so kind of letting me know if any other problem arises so
> I can hopefully fix for this Friday GeoTools release.
>
> Cheers,
>
> Gabrie
>
> On Wednesday 20 August 2008 06:02:07 pm Amr A. Alam wrote:
> > 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:16
> > >>>>>5) at
> > >>>>> org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.
> > >>>>>java
> > >>>>>
> > >>>>> :273) at
> > >>>>>
> > >>>>> org.geotools.arcsde.data.ArcSDEDataStore.getFeatureTypeInfo(ArcSD
> > >>>>>EDat aStore .java:626) at
> > >>>>> org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStor
> > >>>>>e.ja va:170 ) at
> > >>>>> org.geoserver.catalog.util.LegacyCatalogImporter.readFeatureType(
> > >>>>>Lega cyCata logImporter.java:441) at
> > >>>>> org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCata
> > >>>>>logI mporte r.java:154) at
> > >>>>> org.geoserver.config.GeoServerLoader.initialize(GeoServerLoader.j
> > >>>>>ava: 84) at
> > >>>>> org.geoserver.config.GeoServerLoader.postProcessBeforeInitializat
> > >>>>>ion( 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

_________________________________________________________________
Win New York holidays with Kellogg’s & Live Search
http://clk.atdmt.com/UKM/go/107571440/direct/01/

Thank Gabriel,

That fix seems to have dealt with the problem on my end too. The layers are getting added normally now.

Amr.

Gabriel Roldán wrote:

Hi Quincyme,

forwarding the good news to geoserver-users.

Indeed the ArcSDE extension got a major refurbish and the way it handles the connections is way more stable and pretty now.

I'm glad you're finding it useful, please keep posting about any other problem you find.

best regards,

Gabriel
On Thursday 21 August 2008 04:17:57 am q luong wrote:

Hi Gabrie,Amr,

I've tested out your latest gt-arcsde-2.5-SNAPSHOT.jar for
geoserver-1.7.0-beta2 and I'am happy to say the bug GEOT-1954 appears to
have been fixed. Also magically the ArcSDE connection pooling seems to have
stabilized and I no longer un-expectedly run out of connections as was the
case in earlier versions of geoserver.

Thanks very much for this! Geoserver works like a treat for now.

Keep up the good work!

best regards
Quincyme.

From: groldan@anonymised.com
To: aalam@anonymised.com
Subject: Re: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot create
new feature type Date: Wed, 20 Aug 2008 21:54:06 -0300
CC: luongq@anonymised.com

Hi Quincyme, Amr,

please try out the attached jar. The issue at hand was
http://jira.codehaus.org/browse/GEOT-1954 which I fixed today.
Also please be so kind of letting me know if any other problem arises so
I can hopefully fix for this Friday GeoTools release.

Cheers,

Gabrie

On Wednesday 20 August 2008 06:02:07 pm Amr A. Alam wrote:

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:16
5) at
org.geotools.arcsde.data.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.
java

:273) at

org.geotools.arcsde.data.ArcSDEDataStore.getFeatureTypeInfo(ArcSD
EDat aStore .java:626) at
org.geotools.arcsde.data.ArcSDEDataStore.getSchema(ArcSDEDataStor
e.ja va:170 ) at
org.geoserver.catalog.util.LegacyCatalogImporter.readFeatureType(
Lega cyCata logImporter.java:441) at
org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCata
logI mporte r.java:154) at
org.geoserver.config.GeoServerLoader.initialize(GeoServerLoader.j
ava: 84) at
org.geoserver.config.GeoServerLoader.postProcessBeforeInitializat
ion( 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

_________________________________________________________________
Win New York holidays with Kellogg’s & Live Search
http://clk.atdmt.com/UKM/go/107571440/direct/01/

--
Refractions Research
Suite 300 - 1207 Douglas St
Victoria, BC, V8W 2E7, Canada
ph: (250) 383-3022
fax:(250) 383-2140