Hi Bruce,
this problem may be at ArcSDE side. Did you check if the maximum number of connections is reached? Did you try to reach the server where ArcSDE instance is running on with a ping? If that works, try with a telnet connection. What does the SDE log say? Did the connection trial reach the ArcSDE instance?
Kind regards
Albrecht
Albrecht Weiser,
E6, GIS Center
Hessische Zentrale für Datenverarbeitung (HZD)
Mainzer Straße 29, 65185 Wiesbaden
Tel.: 0611 340-3113
Fax: 0611 340-5113
E-Mail: albrecht.weiser@anonymised.com
------------------------------
Message: 2
Date: Thu, 14 Aug 2008 20:06:08 +1000
From: Bruce Bannerman <bruce@anonymised.com>
Subject: [Geoserver-users] [Fwd: GeoServer 1.6.4 and ArcSDE 9.2 SP6]
To: geoserver-users@lists.sourceforge.net
Message-ID: <1218708368.6533.7.camel@anonymised.com>
Content-Type: text/plain; charset="us-ascii"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 +1000Hello GeoServer Users,
Well, I've finally stolen some time to play... sorry.... seriously
evaluate, GeoServerI 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.jarWhen 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
