I'm not sure if this got through to the list. Apologies if it did.
I got a bounce back from my mail server at work.
Bruce
-------- Forwarded Message --------
From: Bruce.Bannerman@anonymised.com
To: geoserver-users@lists.sourceforge.net
Cc: bruce@anonymised.com
Subject: GeoServer 1.6.4 and ArcSDE 9.2 SP6
Date: Thu, 14 Aug 2008 16:15:20 +1000
Hello GeoServer Users,
Well, I've finally stolen some time to play... sorry.... seriously
evaluate, GeoServer
I have a problem getting ArcSDE connectivity with GeoServer. Hopefully
someone can point me in the right direction?
I have a working installation of GeoServer 1.6.4, downloaded from
geoserver.org.
It is running under Ubuntu 8.04, Apache 2.2, Tomcat 5.5, Sun Java 1.6.
I'm trying to set up a connection to our test ArcSDE 9.2 SP6 (on Oracle)
instance. This is set up as an ArcSDE application server.
I have copied the following files into
my /var/lib/tomcat5.5/webapps/geoserver/WEB-INF/lib directory:
gt2-arcsde-2.4.3.jar - from geoserver.org
Plus the following .jar files from my ArcSDE 9.2 SP6 sdk install:
concurrent.jar
icu4j_3_2.jar
jpe92_sdk.jar
jsde92_sdk.jar
When I attempt to define a Datastore in GeoServer referencing a Feature
Class in ArcSDE, I get the following error message when I attempt to
define the ArcSDE connection parameters in the 'Feature Data Set
Editor'.
'Connection Parameters are invalid'.
The connection parameters that I'm using ARE valid.
When I check the geoserver logfile I find the following error message:
======================================================================
2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - No database name
specified
2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - No database name
specified
2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - populating ArcSDE
connection pool
2008-08-14 14:06:38,306 INFO [arcsde.pool] - Created ArcSDE connection
pool for org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
server=<name>, port=60100, instance=null, user=<user>, password=*****,
minConnections=2, maxConnections=6, connTimeOut=500]
2008-08-14 14:06:38,312 WARN [arcsde.pool] - can't connect to
org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
server=<name>, port=60100, instance=null, user=<user>, password=*****,
minConnections=2, maxConnections=6, connTimeOut=500]
org.geotools.arcsde.ArcSdeException: [SDE error -1 Unknown Host -
EDA058810: EDA058810][Error desc=GENERAL FAILURE OCCURRED.][Extended
desc=Unknown Host - EDA058810: EDA058810
]
The 'No database name' is correct with an ArcSDE instance configured on
Oracle. You don't use the database name.
The 'unknown host' that is being referred to here is the PC that I have
GeoServer installed on. This PC does not have ArcSDE installed.
The server refered to has a valid ArcSDE license.
The non-standard port number has not been a problem in the past in other
environments.
Does this sequence ring any bells with anyone?
Bruce Bannerman