Menu
▾
▴
Re: [Geoserver-users] GeoServer 1.7.0-beta2 ArcSDE cannot create new feature type
|
From: Amr A. A. <aa...@re...> - 2008-08-21 16:56:38
|
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: gr...@op... >>> To: aa...@re... >>> 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: lu...@ho... >>> >>> 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: 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: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 >>>>> Geo...@li... >>>>> 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 |
