[Geoserver-users] ArcSDE Support

GeoServer GeoServer User
1

Hi I have just downloaded and installed the WAR version of Geoserver 1.3.2
on Tomcat and I have encountered a couple of issues so far.

First a minor thing. The install doesnt find the states shapefile because
it is stored in webapps\geoserver\data\shapefiles\states.shp rather than
webapps\geoserver\data\featureTypes\states\states.shp where Geoserver
expects to find it. May just be an issue with the states XML found in the
later location I am completely green to Geoserver so dunno the syntax of
this file yet.

Now my main problem is regarding ArcSDE connectivity. I have downloaded
the ArcSDE Extension and loaded the following files in
webapps\geoserver\WEB-INF\lib\

gt2-arcsde.jar
jsde_sdk-8.3.jar

Restarted Tomcat etc... cleaned out the work directory and so forth. I
still do not get any ArcSDE option for new data store. My stdout.log from
Tomcat states this:

1563307 [WARNING] org.geotools.data.arcsde.ArcSDEDataStoreFactory - ArcSDE
Java API seems to not be on your classpath. Please verify that all needed
jars are. ArcSDE data stores will not be available.

Reading the documentation on this it should be enough for these files to
be available in the \WEB-INF\lib directory.

I do have a special situation where I have a global environment variable
set to a specific FME jar file.

CLASSPATH=D:\FME2004\fmeobjects\java\fmeobjects.jar

I didn't design this some 3rd party developer made this ugly hack for
another application.

Could this be the reason why Geoserver doesn't find the jars in the
WEB-INF\lib directory?

I am running Tomcat 4.1.12 on JDK 1.4.2_07

Any help appreciated.

/Jesper

_________________________________________________________________
realestate.com.au: the biggest address in property http://ninemsn.realestate.com.au

2

Which install file did you use, the .war? The states shapefile is showing up on all of the examples I have run here, but maybe it missed something.

Brent Owens
(The Open Planning Project)

Jesper Nielsen wrote:

Hi I have just downloaded and installed the WAR version of Geoserver 1.3.2
on Tomcat and I have encountered a couple of issues so far.

First a minor thing. The install doesnt find the states shapefile because
it is stored in webapps\geoserver\data\shapefiles\states.shp rather than
webapps\geoserver\data\featureTypes\states\states.shp where Geoserver
expects to find it. May just be an issue with the states XML found in the
later location I am completely green to Geoserver so dunno the syntax of
this file yet.

Now my main problem is regarding ArcSDE connectivity. I have downloaded
the ArcSDE Extension and loaded the following files in
webapps\geoserver\WEB-INF\lib\

gt2-arcsde.jar
jsde_sdk-8.3.jar

Restarted Tomcat etc... cleaned out the work directory and so forth. I
still do not get any ArcSDE option for new data store. My stdout.log from
Tomcat states this:

1563307 [WARNING] org.geotools.data.arcsde.ArcSDEDataStoreFactory - ArcSDE
Java API seems to not be on your classpath. Please verify that all needed
jars are. ArcSDE data stores will not be available.

Reading the documentation on this it should be enough for these files to
be available in the \WEB-INF\lib directory.

I do have a special situation where I have a global environment variable
set to a specific FME jar file.

CLASSPATH=D:\FME2004\fmeobjects\java\fmeobjects.jar

I didn't design this some 3rd party developer made this ugly hack for
another application.

Could this be the reason why Geoserver doesn't find the jars in the
WEB-INF\lib directory?

I am running Tomcat 4.1.12 on JDK 1.4.2_07

Any help appreciated.

/Jesper

_________________________________________________________________
realestate.com.au: the biggest address in property http://ninemsn.realestate.com.au

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Hmmm... Just tried it myself, and I think that 8.3 may no longer work? Which shouldn't be the case I don't believe, but I think it's now checking for a file that is only in 9.x? Gabriel or Saul? Any insight into whether we actually really depend on something in 9.x, or if that requirement accidentally got added in the code? I think everything's supposed to be backwards compatible with their jars, and it should with our code as well.

Chris

Jesper Nielsen wrote:

Hi I have just downloaded and installed the WAR version of Geoserver 1.3.2
on Tomcat and I have encountered a couple of issues so far.

First a minor thing. The install doesnt find the states shapefile because
it is stored in webapps\geoserver\data\shapefiles\states.shp rather than
webapps\geoserver\data\featureTypes\states\states.shp where Geoserver
expects to find it. May just be an issue with the states XML found in the
later location I am completely green to Geoserver so dunno the syntax of
this file yet.

Now my main problem is regarding ArcSDE connectivity. I have downloaded
the ArcSDE Extension and loaded the following files in
webapps\geoserver\WEB-INF\lib\

gt2-arcsde.jar
jsde_sdk-8.3.jar

Restarted Tomcat etc... cleaned out the work directory and so forth. I
still do not get any ArcSDE option for new data store. My stdout.log from
Tomcat states this:

1563307 [WARNING] org.geotools.data.arcsde.ArcSDEDataStoreFactory - ArcSDE
Java API seems to not be on your classpath. Please verify that all needed
jars are. ArcSDE data stores will not be available.

Reading the documentation on this it should be enough for these files to
be available in the \WEB-INF\lib directory.

I do have a special situation where I have a global environment variable
set to a specific FME jar file.

CLASSPATH=D:\FME2004\fmeobjects\java\fmeobjects.jar

I didn't design this some 3rd party developer made this ugly hack for
another application.

Could this be the reason why Geoserver doesn't find the jars in the
WEB-INF\lib directory?

I am running Tomcat 4.1.12 on JDK 1.4.2_07

Any help appreciated.

/Jesper

_________________________________________________________________
realestate.com.au: the biggest address in property http://ninemsn.realestate.com.au

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,44ad1b39193392081064789!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

4

That is indeed a good question.

I don't think there's anything that depends on SDE 9.x jars...but I haven't looked through the new 'auto-magically detect' ArcSDE code. I'm still running on a version of the GS code that's 1.3.1/GT-2.1.x based.

I'll be moving to the GS trunk when the 1.4.x merge happens, so I'm sure I'll have a good answer at that point!

--saul

Chris Holmes wrote:

Hmmm... Just tried it myself, and I think that 8.3 may no longer work? Which shouldn't be the case I don't believe, but I think it's now checking for a file that is only in 9.x? Gabriel or Saul? Any insight into whether we actually really depend on something in 9.x, or if that requirement accidentally got added in the code? I think everything's supposed to be backwards compatible with their jars, and it should with our code as well.

Chris

5

Hi guys,
unfortunately the arcsde plugin does depends on the arcsde 9.x jars, in order
to be compatible with both 8.x and 9.x. Making it working with the 8.3 jars
would require having a separate build for the arcsde plugin, since I remember
I had to use the new geometry types constants introduced in 9.x in order to
correctly identify the geometry flags of an SeLayer. I remember having to do
that when I was working with Brent in some performance anhancements for the
plugin and I only had access to 8.x but he had to 9.x.

So Jesper, is there any possibility that you get the 9.x jars legally from
somewhere? I know they come, for example, in service packs for ArcIMS,
ArcExplorer Java, and of course the ArcSDE 9.x client CD.

I am still not sure if you're allowed to copy the jars that comes with
ArcExplorer Java to be used by other application, may be you can read the
license file to figure it out?

Gabriel

On Thursday 06 July 2006 21:05, Saul Farber wrote:

That is indeed a good question.

I don't think there's anything that depends on SDE 9.x jars...but I
haven't looked through the new 'auto-magically detect' ArcSDE code. I'm
still running on a version of the GS code that's 1.3.1/GT-2.1.x based.

I'll be moving to the GS trunk when the 1.4.x merge happens, so I'm sure
I'll have a good answer at that point!

--saul

Chris Holmes wrote:
> Hmmm... Just tried it myself, and I think that 8.3 may no longer work?
> Which shouldn't be the case I don't believe, but I think it's now
> checking for a file that is only in 9.x? Gabriel or Saul? Any insight
> into whether we actually really depend on something in 9.x, or if that
> requirement accidentally got added in the code? I think everything's
> supposed to be backwards compatible with their jars, and it should with
> our code as well.
>
> Chris

--
Gabriel Roldán (groldan@anonymised.com)
Axios Engineering (http://www.axios.es)
Tel. +34 944 41 63 84
Fax. +34 944 41 64 90

6

Hi,

Thanks for this! I have updated to ArcSDE 9.x Java client Jar files in WEB-INF\lib\ and everything is now working. Maybe the doco should be updated to that effect.

Anyway on another note I noticed that Geoserver doesn't auto populate the ESPG code for ArcSDE layers even though the information is stored in ArcSDE?

Is it because the SRTEXT used by GeoServer and ArcSDE is different or is it because GeoServer fails to look it up in SDE?

SDE stores the information here:
SELECT SDE.LAYERS.OWNER, SDE.LAYERS.TABLE_NAME, SDE.SPATIAL_REFERENCES.SRTEXT
FROM SDE.LAYERS, SDE.GEOMETRY_COLUMNS, SDE.SPATIAL_REFERENCES
WHERE SDE.LAYERS.OWNER = SDE.GEOMETRY_COLUMNS.F_TABLE_SCHEMA
AND SDE.LAYERS.TABLE_NAME = SDE.GEOMETRY_COLUMNS.F_TABLE_NAME
AND SDE.GEOMETRY_COLUMNS.SRID = SDE.SPATIAL_REFERENCES.SRID ;

In my corner of the world it stores these values in ArcSDE for ESPG-4283:
GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]

Geoserver ESPG-4283:
GEOGCS["GDA94", DATUM["Geocentric_Datum_of_Australia_1994", SPHEROID["GRS 1980", 6378137.0, 298.257222101, AUTHORITY["EPSG","7019"]], TOWGS84[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY["EPSG","6283"]], PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], UNIT["degree", 0.017453292519943295], AXIS["Lon", EAST], AXIS["Lat", NORTH], AUTHORITY["EPSG","4283"]]

So the strings are quite different I guess....

Anyway just a thought. Thanks for the help, much appreciated.

/Jesper

BTW. The problem I encountered with the location of the states shapefile was in the WAR download from sourceforge.

From: Gabriel Roldán <groldan@anonymised.com>
To: Saul Farber <Saul.Farber@anonymised.com>
CC: Chris Holmes <cholmes@anonymised.com>, Jesper Nielsen <jkn_73@anonymised.com>, geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ArcSDE Support
Date: Thu, 6 Jul 2006 22:08:33 +0200

Hi guys,
unfortunately the arcsde plugin does depends on the arcsde 9.x jars, in order
to be compatible with both 8.x and 9.x. Making it working with the 8.3 jars
would require having a separate build for the arcsde plugin, since I remember
I had to use the new geometry types constants introduced in 9.x in order to
correctly identify the geometry flags of an SeLayer. I remember having to do
that when I was working with Brent in some performance anhancements for the
plugin and I only had access to 8.x but he had to 9.x.

So Jesper, is there any possibility that you get the 9.x jars legally from
somewhere? I know they come, for example, in service packs for ArcIMS,
ArcExplorer Java, and of course the ArcSDE 9.x client CD.

I am still not sure if you're allowed to copy the jars that comes with
ArcExplorer Java to be used by other application, may be you can read the
license file to figure it out?

Gabriel

On Thursday 06 July 2006 21:05, Saul Farber wrote:
> That is indeed a good question.
>
> I don't think there's anything that depends on SDE 9.x jars...but I
> haven't looked through the new 'auto-magically detect' ArcSDE code. I'm
> still running on a version of the GS code that's 1.3.1/GT-2.1.x based.
>
> I'll be moving to the GS trunk when the 1.4.x merge happens, so I'm sure
> I'll have a good answer at that point!
>
> --saul
>
> Chris Holmes wrote:
> > Hmmm... Just tried it myself, and I think that 8.3 may no longer work?
> > Which shouldn't be the case I don't believe, but I think it's now
> > checking for a file that is only in 9.x? Gabriel or Saul? Any insight
> > into whether we actually really depend on something in 9.x, or if that
> > requirement accidentally got added in the code? I think everything's
> > supposed to be backwards compatible with their jars, and it should with
> > our code as well.
> >
> > Chris

--
Gabriel Roldán (groldan@anonymised.com)
Axios Engineering (http://www.axios.es)
Tel. +34 944 41 63 84
Fax. +34 944 41 64 90

_________________________________________________________________
New year, new job – there's more than 100,00 jobs at SEEK http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn.seek.com.au&_t=752315885&_r=Jan05_tagline&_m=EXT

7

On Friday 07 July 2006 03:45, Jesper Nielsen wrote:

Hi,

Thanks for this! I have updated to ArcSDE 9.x Java client Jar files in
WEB-INF\lib\ and everything is now working.

nice

Maybe the doco should be
updated to that effect.

done.

Anyway on another note I noticed that Geoserver doesn't auto populate the
ESPG code for ArcSDE layers even though the information is stored in
ArcSDE?

The geotools arcsde plugin module maintainer does not knows how to match a CRS
parsed from the ArcSDE WKT with an EPSG defined one :frowning:
It might even be necessary to define another authority for ESRI defined CRS's,
but again, the module maintainer is pretty ignorant about this stuff, so he
would appreciate any help on this regard :slight_smile:

cheers,

Gabriel

Is it because the SRTEXT used by GeoServer and ArcSDE is different or is it
because GeoServer fails to look it up in SDE?

SDE stores the information here:
SELECT SDE.LAYERS.OWNER, SDE.LAYERS.TABLE_NAME,
SDE.SPATIAL_REFERENCES.SRTEXT
FROM SDE.LAYERS, SDE.GEOMETRY_COLUMNS, SDE.SPATIAL_REFERENCES
WHERE SDE.LAYERS.OWNER = SDE.GEOMETRY_COLUMNS.F_TABLE_SCHEMA
AND SDE.LAYERS.TABLE_NAME = SDE.GEOMETRY_COLUMNS.F_TABLE_NAME
AND SDE.GEOMETRY_COLUMNS.SRID = SDE.SPATIAL_REFERENCES.SRID ;

In my corner of the world it stores these values in ArcSDE for ESPG-4283:
GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994",SPHEROID["GRS_1980",6378137.0,298.
257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]

Geoserver ESPG-4283:
GEOGCS["GDA94", DATUM["Geocentric_Datum_of_Australia_1994", SPHEROID["GRS
1980", 6378137.0, 298.257222101, AUTHORITY["EPSG","7019"]], TOWGS84[0.0,
0.0, 0.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY["EPSG","6283"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], UNIT["degree",
0.017453292519943295], AXIS["Lon", EAST], AXIS["Lat", NORTH],
AUTHORITY["EPSG","4283"]]

So the strings are quite different I guess....

Anyway just a thought. Thanks for the help, much appreciated.

/Jesper

BTW. The problem I encountered with the location of the states shapefile
was in the WAR download from sourceforge.

>From: Gabriel Roldفn <groldan@anonymised.com>
>To: Saul Farber <Saul.Farber@anonymised.com>
>CC: Chris Holmes <cholmes@anonymised.com>, Jesper Nielsen
><jkn_73@anonymised.com>, geoserver-users@lists.sourceforge.net
>Subject: Re: [Geoserver-users] ArcSDE Support
>Date: Thu, 6 Jul 2006 22:08:33 +0200
>
>Hi guys,
>unfortunately the arcsde plugin does depends on the arcsde 9.x jars, in
>order
>to be compatible with both 8.x and 9.x. Making it working with the 8.3
> jars would require having a separate build for the arcsde plugin, since I
> remember
>I had to use the new geometry types constants introduced in 9.x in order
> to correctly identify the geometry flags of an SeLayer. I remember having
> to do
>that when I was working with Brent in some performance anhancements for
> the plugin and I only had access to 8.x but he had to 9.x.
>
>So Jesper, is there any possibility that you get the 9.x jars legally from
>somewhere? I know they come, for example, in service packs for ArcIMS,
>ArcExplorer Java, and of course the ArcSDE 9.x client CD.
>
>I am still not sure if you're allowed to copy the jars that comes with
>ArcExplorer Java to be used by other application, may be you can read the
>license file to figure it out?
>
>Gabriel
>
>On Thursday 06 July 2006 21:05, Saul Farber wrote:
> > That is indeed a good question.
> >
> > I don't think there's anything that depends on SDE 9.x jars...but I
> > haven't looked through the new 'auto-magically detect' ArcSDE code.
> > I'm still running on a version of the GS code that's 1.3.1/GT-2.1.x
> > based.
> >
> > I'll be moving to the GS trunk when the 1.4.x merge happens, so I'm
> > sure I'll have a good answer at that point!
> >
> > --saul
> >
> > Chris Holmes wrote:
> > > Hmmm... Just tried it myself, and I think that 8.3 may no longer
>
>work?
>
> > > Which shouldn't be the case I don't believe, but I think it's now
> > > checking for a file that is only in 9.x? Gabriel or Saul? Any
>
>insight
>
> > > into whether we actually really depend on something in 9.x, or if
> > > that requirement accidentally got added in the code? I think
> > > everything's supposed to be backwards compatible with their jars, and
> > > it should
>
>with
>
> > > our code as well.
> > >
> > > Chris
>
>--
>Gabriel Roldفn (groldan@anonymised.com)
>Axios Engineering (http://www.axios.es)
>Tel. +34 944 41 63 84
>Fax. +34 944 41 64 90

_________________________________________________________________
New year, new job – there's more than 100,00 jobs at SEEK
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn.seek.com.au&_
t=752315885&_r=Jan05_tagline&_m=EXT

--
Gabriel Roldán (groldan@anonymised.com)
Axios Engineering (http://www.axios.es)
Tel. +34 944 41 63 84
Fax. +34 944 41 64 90

8

Jesper Nielsen wrote:

Hi,

Thanks for this! I have updated to ArcSDE 9.x Java client Jar files in WEB-INF\lib\ and everything is now working. Maybe the doco should be updated to that effect.

Where did you find the jars? I'd like to give hints in the docs where people can find them.

C