[Geoserver-users] re: arcsde problem

Hi Msf,

please keep on cc'ing the geoserver users list for all our communication.

effectively the stack would be openlayers-geoserver-arcsde-data

GeoTools is the core geospatial library used by geoserver, so you wouldn't be working directly with geotools but through geoserver. If, by the other hand, among using GeoServer to serve your data through OGC web services you need to develop a custom application to process or integrate your data with other systems, etc, GeoTools would be your best shot as the geospatial library to use for that purpose. To learn more about GeoTools you can refer to the user's guide at <http://docs.codehaus.org/display/GEOTDOC/Home&gt;\.

Best regards,

Gabriel

shaofei ma wrote:

Gabriel,
I saw some project used the geoserver+geotools+openlayers+tomcat structure. GeoTools is opensource too. I knew openlayers is working in the client and geotools is working in the server. I have a problem that if we can operate the map directly by openlayers and geoserver, then what is geotools purpose?
Your friend,
Msf

------------------------------------------------------------------------
*发件人:* Gabriel Roldan <groldan@anonymised.com>
*收件人:* mashaofei@anonymised.com
*已发送:* 2009/4/10(周五), 下午11:38:49
*主题:* Re: arcsde problem

Hi Msf,

Indeed, GeoServer can connect to the ArcSDE service, but not to ArcGIS Server. If you had the arcsde database gateway installed and running (default port is 5151) you could connect and fetch data directly from it. So in this scenario I guess both GeoServer and ArcGIS server would be hitting the same ArcSDE instance, but GeoServer can't be an ArcGIS Server client so far.

Best regards,

Gabriel

mashaofei@anonymised.com <mailto:mashaofei@anonymised.com> wrote:
> Gabriel,
>
> Thanks for your help! my english is poor and i hope you can
> understand what i want to express.
>
> I didn't study GIS before. But now i have to study it to finish my
> job. We want to build the gis application by geoserver. Customer have
> a ArcGis app. What we want to do is use geoserver to connect the
> ArcGis server, then our app can share the arcgis database. I found
> Geoserver can use ArcGis database by ArcSde.
>
> I want to konw what shall we do?
>
> shall i install the arcsde at first? i have downloaded the required
> jar files, like geoserver arcsde plugin files. and i also have
> download jsde92_sdk.jar,jpe92_sdk.jar and icu4j_3_2.jar. Those jar
> files have been put into the Geoserver lib folder. i can see the
> "arcsde" type in the droplist box in the geoserver store setting
> page. But it failed to connect and reported error as you have seen.
>
> i use the geoserver 1.7.3. Arcgis server for java version is 9.2 and
> database is oracle.
>
> Your friend,
>
> Msf
>
> ------------------------------------------------------------------------------------------------------------------------
> Gabriel Roldan wrote:
>> Hi, it seems to me like the "port" parameter is wrong, at least you
>> actually have the instance running on port 5300, but what makes it
>> suspicious is that that is the default port for ArcIMS, for ArcSDE
>> it is 5151.
>>
>> Can you check and if that's not the problem give me back some more
>> information like sde version, database flavor and geoserver
>> version?
>>
>> best regards,
>>
>> Gabriel youme wrote:
>>> I'm trying to set up the arcsde and the log report as follow.
>>> What's wrong whit it? The Aicgis server is on local pc. I want to
>>> use the arcgis map data by geoserver. I have downloaded and fixed
>>> the jars in the lib folder. I can seen the arcsde in the droplist
>>> box. I have choosed the arcsde type and filled the other info,
>>> like username, password. When I clicked the button it reported
>>> the error infomations.
>>>
>>> 2009-04-09 16:56:44,812 WARN [geoserver.action] - Unable to fetch
>>> a list of FeatureType names from datastore. org.geotools.arcsde.ArcSdeException: [SDE error -121 Connection
>>> refused: connect][Error desc=NO INSTANCE RUNNING ON
>>> SERVER.][Extended desc=Connection refused: connect ] at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:205) at
>>> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>>> at java.lang.Thread.run(Thread.java:619) Caused by:
>>> com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
>>> com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:202) ... 5
>>> more
>>>
>>> tomcat log: ...... form connection params { port=5300,
>>> dbtype="arcsde", pool.timeOut=500, server=" localhost",
>>> instance="usa", pool.maxConnections=6, password="123", user="arcgism anager", pool.minConnections=2} 09 15:59:32 ERROR
>>> [arcsde.pool] - Command execution failed for Session 0 in thread
>>> 54 org.geotools.arcsde.ArcSdeException: [SDE error -121
>>> Connection refused: connect ][Error desc=NO INSTANCE RUNNING ON
>>> SERVER.][Extended desc=Connection refused: c onnect ] at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:205) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
>>> utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
>>> .java:908) at java.lang.Thread.run(Thread.java:619) Caused by:
>>> com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
>>> com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:202) ... 5
>>> more 09 15:59:32 WARN [geoserver.action] - Unable to fetch a list
>>> of FeatureType names from datastore. org.geotools.arcsde.ArcSdeException: [SDE error -121 Connection
>>> refused: connect ][Error desc=NO INSTANCE RUNNING ON
>>> SERVER.][Extended desc=Connection refused: c onnect ] at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:205) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
>>> utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
>>> .java:908) at java.lang.Thread.run(Thread.java:619) Caused by:
>>> com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
>>> com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
>>> org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
>>> org.geotools.arcsde.pool.Session$2.call(Session.java:202) ... 5
>>> more
>>>
>>
>> -- Gabriel Roldan OpenGeo - http://opengeo.org/&gt; Expert service
>> straight from the developers.
>>
>> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by: High Quality Requirements in a
>> Collaborative Environment. Download a free trial of Rational
>> Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Geoserver-users
>> mailing list Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
> Quoted from:
> http://www.nabble.com/arcsde-problem-tp22966879p22987661.html
>

-- Gabriel Roldan
OpenGeo - http://opengeo.org/&gt;
Expert service straight from the developers.

------------------------------------------------------------------------
好玩贺卡等你发,邮箱贺卡全新上线! <http://cn.rd.yahoo.com/mail_cn/tagline/card/*http://card.mail.cn.yahoo.com/&gt;

--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Hi Gabriel,

I found that arcsde is spatial database engine. But the customer GIS application is using the map data which ArcGis server published files, like mxd or other format files. The customer didn’t use ArcSde. If geoserver cann’t use the ArcGis server map sevice directly, how can geoserver use the mxd files? Or, how can geoserver use the files through arcsde?

Thank you in advance.

Your friend,
Msf.


发件人: Gabriel Roldan groldan@anonymised.com
收件人: shaofei ma mashaofei@anonymised.com; “geoserver-users@lists.sourceforge.netgeoserver-users@lists.sourceforge.net
已发送: 2009/4/11(周六), 下午10:12:11
主题: Re: re: arcsde problem

Hi Msf,

please keep on cc’ing the geoserver users list for all our communication.

effectively the stack would be openlayers-geoserver-arcsde-data

GeoTools is the core geospatial library used by geoserver, so you wouldn’t be working directly with geotools but through geoserver. If, by the other hand, among using GeoServer to serve your data through OGC web services you need to develop a custom application to process or integrate your data with other systems, etc, GeoTools would be your best shot as the geospatial library to use for that purpose. To learn more about GeoTools you can refer to the user’s guide at <http://docs.codehaus.org/display/GEOTDOC/Home>.

Best regards,

Gabriel

shaofei ma wrote:

Gabriel,
I saw some project used the geoserver+geotools+openlayers+tomcat structure. GeoTools is opensource too. I knew openlayers is working in the client and geotools is working in the server. I have a problem that if we can operate the map directly by openlayers and geoserver, then what is geotools purpose?
Your friend,
Msf


发件人: Gabriel Roldan <groldan@anonymised.com>
收件人: mashaofei@anonymised.com
已发送: 2009/4/10(周五), 下午11:38:49
主题: Re: arcsde problem

Hi Msf,

Indeed, GeoServer can connect to the ArcSDE service, but not to ArcGIS Server. If you had the arcsde database gateway installed and running (default port is 5151) you could connect and fetch data directly from it. So in this scenario I guess both GeoServer and ArcGIS server would be hitting the same ArcSDE instance, but GeoServer can’t be an ArcGIS Server client so far.

Best regards,

Gabriel

mashaofei@anonymised.com mailto:[mashaofei@anonymised.com](mailto:mashaofei@anonymised.com) wrote:

Gabriel,

Thanks for your help! my english is poor and i hope you can
understand what i want to express.

I didn’t study GIS before. But now i have to study it to finish my
job. We want to build the gis application by geoserver. Customer have
a ArcGis app. What we want to do is use geoserver to connect the
ArcGis server, then our app can share the arcgis database. I found
Geoserver can use ArcGis database by ArcSde.

I want to konw what shall we do?

shall i install the arcsde at first? i have downloaded the required
jar files, like geoserver arcsde plugin files. and i also have
download jsde92_sdk.jar,jpe92_sdk.jar and icu4j_3_2.jar. Those jar
files have been put into the Geoserver lib folder. i can see the
“arcsde” type in the droplist box in the geoserver store setting
page. But it failed to connect and reported error as you have seen.

i use the geoserver 1.7.3. Arcgis server for java version is 9.2 and
database is oracle.

Your friend,

Msf


Gabriel Roldan wrote:

Hi, it seems to me like the “port” parameter is wrong, at least you
actually have the instance running on port 5300, but what makes it
suspicious is that that is the default port for ArcIMS, for ArcSDE
it is 5151.

Can you check and if that’s not the problem give me back some more
information like sde version, database flavor and geoserver
version?

best regards,

Gabriel youme wrote:

I’m trying to set up the arcsde and the log report as follow.
What’s wrong whit it? The Aicgis server is on local pc. I want to
use the arcgis map data by geoserver. I have downloaded and fixed
the jars in the lib folder. I can seen the arcsde in the droplist
box. I have choosed the arcsde type and filled the other info,
like username, password. When I clicked the button it reported
the error infomations.

2009-04-09 16:56:44,812 WARN [geoserver.action] - Unable to fetch
a list of FeatureType names from datastore. org.geotools.arcsde.ArcSdeException: [SDE error -121 Connection
refused: connect][Error desc=NO INSTANCE RUNNING ON
SERVER.][Extended desc=Connection refused: connect ] at
org.geotools.arcsde.pool.Session$2.call(Session.java:205) at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619) Caused by:
com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
com.esri.sde.sdk.client.SeConnection.(Unknown Source) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
org.geotools.arcsde.pool.Session$2.call(Session.java:202) … 5
more

tomcat log: … form connection params { port=5300,
dbtype=“arcsde”, pool.timeOut=500, server=" localhost",
instance=“usa”, pool.maxConnections=6, password=“123”, user=“arcgism anager”, pool.minConnections=2} 09 15:59:32 ERROR
[arcsde.pool] - Command execution failed for Session 0 in thread
54 org.geotools.arcsde.ArcSdeException: [SDE error -121
Connection refused: connect ][Error desc=NO INSTANCE RUNNING ON
SERVER.][Extended desc=Connection refused: c onnect ] at
org.geotools.arcsde.pool.Session$2.call(Session.java:205) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908) at java.lang.Thread.run(Thread.java:619) Caused by:
com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
com.esri.sde.sdk.client.SeConnection.(Unknown Source) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
org.geotools.arcsde.pool.Session$2.call(Session.java:202) … 5
more 09 15:59:32 WARN [geoserver.action] - Unable to fetch a list
of FeatureType names from datastore. org.geotools.arcsde.ArcSdeException: [SDE error -121 Connection
refused: connect ][Error desc=NO INSTANCE RUNNING ON
SERVER.][Extended desc=Connection refused: c onnect ] at
org.geotools.arcsde.pool.Session$2.call(Session.java:205) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908) at java.lang.Thread.run(Thread.java:619) Caused by:
com.esri.sde.sdk.client.SeException: Connection refused: connect at com.esri.sde.sdk.client.SeConnection.v(Unknown Source) at
com.esri.sde.sdk.client.SeConnection.(Unknown Source) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:146) at
org.geotools.arcsde.pool.Session$1.execute(Session.java:138) at
org.geotools.arcsde.pool.Session$2.call(Session.java:202) … 5
more

– Gabriel Roldan OpenGeo - http://opengeo.org <http://opengeo.org/> Expert service
straight from the developers.


This SF.net email is sponsored by: High Quality Requirements in a
Collaborative Environment. Download a free trial of Rational
Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Geoserver-users
mailing list Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net) https://lists.sourceforge.net/lists/listinfo/geoserver-users

Quoted from:
http://www.nabble.com/arcsde-problem-tp22966879p22987661.html

– Gabriel Roldan
OpenGeo - http://opengeo.org <http://opengeo.org/>
Expert service straight from the developers.


好玩贺卡等你发,邮箱贺卡全新上线! <http://cn.rd.yahoo.com/mail_cn/tagline/card/*http://card.mail.cn.yahoo.com/>

– Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.


好玩贺卡等你发,邮箱贺卡全新上线!