[Geoserver-users] arcsde plugin help

Otterson_Barry_SE · October 30, 2007, 8:19pm

We have not been able to connect to ArcSDE 9.1 as of yet. We are working on the plugin as per the instructions from

here; http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore

Do any users have experience with the ArcSDE plugin that could help us trouble-shoot it?

Currently we do not see the ArcSDE option at all in the DataStores list, just the standard POSTGIS, PROPERTIES, SHAPEFILE, VERSIONING POSTGIS and WFS. We are using GeoServer Beta 4 on a windows 2003 server virtual machine.

Thanks in Advance,

barry

Saul_Farber · October 30, 2007, 8:53pm

Hey barry,

I got the heads up from Josh that you were running into trouble on this.

Here's a brief recap of what you need to do:

First get a copy of gt2-arcsde.jar.

for use with geoserver-1.5.x:
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.3.5-SNAPSHOT/gt2-arcsde-2.3.5-SNAPSHOT.jar

for use with geoserver-1.6.x:
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SNAPSHOT/gt2-arcsde-2.4-SNAPSHOT.jar

Then:
1) Download a clean geoserver (either 1.5.x or 1.6.x)
2) Download the gt2-arcsde.jar file that's relevant to your geoserver
install (see above links)
3) Also include the jsde_xxx.jar files that you got from ArcSDE
directly (the esri developers SDK, or else download them from the links
here: http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore)
4) Put all these files (from 2 & 3) into the geoserver/WEB-INF/lib
directory, restart geoserver and you should be all set!

Sorry the docs on that page are out of date. We're working on it!

Let me know if that helps,
--saul

On Tue, 2007-10-30 at 14:19 -0600, Otterson, Barry SE wrote:

We have not been able to connect to ArcSDE 9.1 as of yet. We are
working on the plugin as per the instructions from

here; http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore

>

Do any users have experience with the ArcSDE plugin that could help us
trouble-shoot it?

Currently we do not see the ArcSDE option at all in the DataStores
list, just the standard POSTGIS, PROPERTIES, SHAPEFILE, VERSIONING
POSTGIS and WFS. We are using GeoServer Beta 4 on a windows 2003
server virtual machine.

Thanks in Advance,

barry

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users

Bob_Nutsch · October 30, 2007, 9:01pm

Hi Barry,

I’ve been able to connect to ArcSDE 9.0 and 9.2 using 1.6 beta (currently beta 4). My environment is GeoServer running on XP and ArcSDE running with Oracle. After freshly installing GeoServer, I do the following:

copy the 3 ArcSDE .jar files from your ArcSDE (e.g., icu4j_3_2.jar, jpe92_sdk.jar, jsde92_sdk.jar that are found in C:\ArcGIS\ArcSDE\lib) into your GeoServer lib directory, e.g., C:\Tomcat55\webapps\geoserver\WEB-INF\lib (note that I am running GeoServer with Tomcat. I believe that whatever servlet engine you are running you should have a WEB-INF\lib.)
download http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SNAPSHOT/gt2-arcsde-2.4-SNAPSHOT.jar and drop it into the WEB-INF/lib directory
restart GeoServer (or your servlet engine) and you should be good to go.

Note that I did have a variety of issues that you may or may not come across. For example, the current beta as far as I know does not yet allow us to access ArcSDE raster data for those running on windows. This is a known issue and will be fixed soon I believe. Other things that I came across in the beta 1.6 version and was able to solve through the generous help of others on the GeoServer forum includes a) don’t have spaces in your GeoServer install path, b) don’t have spaces in your Tomcat install path, and c) you need to have Java Advanced Imaging (JAI) in place. These last items may not apply to you and I believe they will be fixed at some point, but I thought I’d give you a heads-up in case you see weird Java crashes.

Regards, Bob

From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Otterson, Barry SE
Sent: Tuesday, October 30, 2007 3:19 PM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] arcsde plugin help

We have not been able to connect to ArcSDE 9.1 as of yet. We are working on the plugin as per the instructions from

here; http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore

Do any users have experience with the ArcSDE plugin that could help us trouble-shoot it?

Currently we do not see the ArcSDE option at all in the DataStores list, just the standard POSTGIS, PROPERTIES, SHAPEFILE, VERSIONING POSTGIS and WFS. We are using GeoServer Beta 4 on a windows 2003 server virtual machine.

Thanks in Advance,

barry

prushforth · October 31, 2007, 1:08pm

Hi Saul,

Thanks for chipping in... I have a quick question related to
Barry's implementation of GeoServer: once he gets the service
up and running, is GeoServer on ArcSDE capable of processing
filter requests such as ogc:Within, ogc:Overlaps etc.? The reason I ask
is that I have tested another instance of GeoServer on POSTGIS,
and it clearly doesn't process those requests, or processes them
incorrectly, returning empty feature collections where I know
there should be a few results.

Cheers,
Peter

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On
Behalf Of Saul Farber
Sent: October 30, 2007 16:53
To: Otterson, Barry SE
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] arcsde plugin help

Hey barry,

I got the heads up from Josh that you were running into
trouble on this.

Here's a brief recap of what you need to do:

First get a copy of gt2-arcsde.jar.

for use with geoserver-1.5.x:
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.3.5-
SNAPSHOT/gt2-arcsde-2.3.5-SNAPSHOT.jar

for use with geoserver-1.6.x:
http://lists.refractions.net/m2/org/geotools/gt2-arcsde/2.4-SN

APSHOT/gt2-arcsde-2.4-SNAPSHOT.jar

Then:
1) Download a clean geoserver (either 1.5.x or 1.6.x)
2) Download the gt2-arcsde.jar file that's relevant to your
geoserver install (see above links)
3) Also include the jsde_xxx.jar files that you got from
ArcSDE directly (the esri developers SDK, or else download
them from the links
here: http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore)
4) Put all these files (from 2 & 3) into the
geoserver/WEB-INF/lib directory, restart geoserver and you
should be all set!

Sorry the docs on that page are out of date. We're working on it!

Let me know if that helps,
--saul

On Tue, 2007-10-30 at 14:19 -0600, Otterson, Barry SE wrote:
> We have not been able to connect to ArcSDE 9.1 as of yet. We are
> working on the plugin as per the instructions from
>
> here; http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore
>
> >
>
> Do any users have experience with the ArcSDE plugin that
could help us
> trouble-shoot it?
>
>
>
> Currently we do not see the ArcSDE option at all in the DataStores
> list, just the standard POSTGIS, PROPERTIES, SHAPEFILE, VERSIONING
> POSTGIS and WFS. We are using GeoServer Beta 4 on a windows 2003
> server virtual machine.
>
>
>
>
>
> Thanks in Advance,
>
>
>
> barry
>
>
>
>
>
----------------------------------------------------------------------
> --- This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX
and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________ Geoserver-users
> mailing list Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--------------------------------------------------------------
-----------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and
a browser.
Download your FREE copy of Splunk now >>
http://get.splunk.com/ _______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Andrea_Aime3 · October 31, 2007, 1:12pm

Rushforth, Peter ha scritto:

Hi Saul,

Thanks for chipping in... I have a quick question related to
Barry's implementation of GeoServer: once he gets the service
up and running, is GeoServer on ArcSDE capable of processing
filter requests such as ogc:Within, ogc:Overlaps etc.? The reason I ask
is that I have tested another instance of GeoServer on POSTGIS,
and it clearly doesn't process those requests, or processes them
incorrectly, returning empty feature collections where I know
there should be a few results.

He? You should have reported this, because if this is so, then
we have a bug. As far as I know geoserver encodes both within
and overlaps in the corresponding postgis operators.
Can you provide us with a sample dataset and the query that's
not working for you? The OpenGIS WFS test suite explicitly
tests these operators as far as I remember, and we do pass it
with a postgis datastore on the backend.

Cheers
Andrea

prushforth · October 31, 2007, 1:16pm

I discovered it late last night. I will submit a bug report today,
and some sample data and a query.

Cheers,
Peter

-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: October 31, 2007 09:12
To: Rushforth, Peter
Cc: Saul Farber; Otterson, Barry SE;
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] arcsde plugin help

Rushforth, Peter ha scritto:
> Hi Saul,
>
> Thanks for chipping in... I have a quick question related
to Barry's
> implementation of GeoServer: once he gets the service up
and running,
> is GeoServer on ArcSDE capable of processing filter
requests such as
> ogc:Within, ogc:Overlaps etc.? The reason I ask is that I
have tested
> another instance of GeoServer on POSTGIS, and it clearly doesn't
> process those requests, or processes them incorrectly,
returning empty
> feature collections where I know there should be a few results.

He? You should have reported this, because if this is so,
then we have a bug. As far as I know geoserver encodes both
within and overlaps in the corresponding postgis operators.
Can you provide us with a sample dataset and the query that's
not working for you? exThe OpenGIS WFS test suiteplicitly
tests these operators as far as I remember, and we do pass it
with a postgis datastore on the backend.

Cheers
Andrea

prushforth · October 31, 2007, 3:37pm

Hi Andrea,

I tried to sign up to log in to submit a bug report here:
http://jira.codehaus.org/secure/Signup!default.jspa

but it's broken.

So here's my bug report...

GeoServer 1.6 beta 2 (and probably greater) on postgis at
least maybe other data stores, will not process ogc:Within,
ogc:Overlaps, filter operators etc correctly. Occasionally, it returns
SQL errors from postgis, but more usually returns an empty
feature collection.

I attach an example wfs query, which will probably get
filtered by the list, as well as a small sample point data set which
falls within that filter. Data is in EPSG:4326.

Cheers,
Peter Rushforth
Technology Advisor / Conseiller technique
GeoConnections / GéoConnexions
650-615 Booth St. / rue Booth
Ottawa ON K1A 0E9
E-mail / Courriel: Peter.Rushforth@anonymised.com
Phone / Télephone: (613) 943-0784
Fax / telecopier: (613) 947-2410

AFewPlaceNames.gml (132 KB)

GetPlaceNamesInPolygon.wfs (76.6 KB)