Hi Stefano.
You may want to use the 9.3 jars from your ArcSDE Java SDK installation. My impression is on a service pack they may provide only one of the jars if it needs to be updated, and may not include the one that doesn't need to. That is, I don't think the jars can be safely downloaded but esri docs always seem to require you to grab the jars from the ArcSDE Java SDK installation dir, and they encourage you for the client and server versions to match. (I actually seem to recall finding things that fail if they don't, specially using the 9.2 jars over a 9.3 instance).
That said, it is not clear to me if you were indeed able to configure your arcsde coveragestore in geoserver and then failed to query it, or you couldn't neither configure the store?
The log traces you sent seem to be about a DataStore configuration, not a coverage store (I don't see any arcsde.gce log there, only arcsde.data ones).
The URL format you used looks good, I just can't figure out where you got stuck.
as a side note, I know connecting to ArcSDE through that URL thing is ugly. It's just a product of the current GeoTools coverage API being designed for files only. We're waiting for the new API GeoSolutions is working on.
Cheers,
Gabriel
Stefano Iacovella wrote:
Hi Gabriel
I'm finding similar trouble with ArcSDE Raster.
My configuration is:
1) Geoserver Box = Windows XP + jdk 1.6.0 + Tomcat 6.0.18 + Geoserver 1.7.5 with ArcSDE Plugin
2) ArcSDE box = Ubuntu 8.10 + Oracle 11g + ArcSDE 9.3
I had some trouble finding sdk jar for the 9.3 release of ArcSDE. I downloaded the sdk archive form support.esri.com <http://support.esri.com> but it seems to contain just the jpe_sdk.jar. I used the jpe92_sdk.jar and jsde92_sdk.jar. I tried the installation with a vector layer, it seems to work properly.
I tried to configure a raster layer, previously created with sderaster -o import and -o mosaic. I can see the ArcSDE raster option in the new coveragestore list.
I used this url:
sde://sit_adm:tisbd@anonymised.com:5151/#SIT_ADM.ORTOFOTO
SIT_ADM is the Oracle user and owner of ORTOFOTO table.
I tried to visualize ORTOFOTO layer with ArcCatalog with success.
I get a look at geoserver.log but I can't find any error inside.
30 giu 16:53:15 DEBUG [arcsde.ArcSDERasterFormatFactory] - Checking availability of ArcSDE Jars.
30 giu 16:53:15 DEBUG [arcsde.ArcSDERasterFormatFactory] - com.esri.sde.sdk.client.SeConnection is in place.
30 giu 16:53:15 DEBUG [arcsde.ArcSDERasterFormatFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
30 giu 16:53:15 DEBUG [gdal.ecw] - ECWFormatFactory is not availaible.
30 giu 16:53:15 DEBUG [gdal.dted] - DTEDFormatFactory is not availaible.
30 giu 16:53:15 DEBUG [gce.arcgrid] - Creating a new ArcGriFormat.
30 giu 16:53:15 DEBUG [geoserver.filters] - filtering http://localhost:8080/geoserver/images/gs.gif
30 giu 16:53:43 TRACE [arcsde.pool] - activating connection Session[20]
30 giu 16:53:43 TRACE [arcsde.pool] - passivating connection Session[20]
30 giu 16:53:43 TRACE [arcsde.pool] - activating connection Session[19]
30 giu 16:53:43 TRACE [arcsde.pool] - passivating connection Session[19]
30 giu 16:53:44 DEBUG [arcsde.data] - FeatureTypeCache background process running...
30 giu 16:53:44 TRACE [arcsde.pool] - activating connection Session[19]
30 giu 16:53:44 DEBUG [arcsde.pool] - -->Session[19] out of connection pool. Active: 1, idle: 1
30 giu 16:53:44 TRACE [arcsde.pool] - passivating connection Session[19]
30 giu 16:53:44 DEBUG [arcsde.pool] - <-- Session[19] retured to pool. Active: 0, idle: 2
30 giu 16:53:44 DEBUG [arcsde.data] - Finished updated type name cache
30 giu 16:54:13 TRACE [arcsde.pool] - activating connection Session[19]
30 giu 16:54:13 TRACE [arcsde.pool] - passivating connection Session[19]
30 giu 16:54:13 TRACE [arcsde.pool] - activating connection Session[20]
30 giu 16:54:13 TRACE [arcsde.pool] - passivating connection Session[20]
30 giu 16:54:14 DEBUG [arcsde.data] - FeatureTypeCache background process running...
30 giu 16:54:14 TRACE [arcsde.pool] - activating connection Session[20]
30 giu 16:54:14 DEBUG [arcsde.pool] - -->Session[20] out of connection pool. Active: 1, idle: 1
30 giu 16:54:14 TRACE [arcsde.pool] - passivating connection Session[20]
30 giu 16:54:14 DEBUG [arcsde.pool] - <-- Session[20] retured to pool. Active: 0, idle: 2
30 giu 16:54:14 DEBUG [arcsde.data] - Finished updated type name cache
30 giu 16:54:20 DEBUG [geoserver.filters] - filtering http://localhost:8080/geoserver/config/data/formatSubmit.do
30 giu 16:54:20 DEBUG [geoserver.filters] - filtering http://localhost:8080/geoserver/images/gs.gif
Could you find an error in my procedure?
Thanks a lot in advance
PS
2009/5/13 Gabriel Roldan <groldan@anonymised.com <mailto:groldan@anonymised.com>>
Hi Victor,
hmmm that is weird. I am running geoserver 1.7.x agains a number of
ArcSDE rasters with no problem.
Question: what database are you running ArcSDE on top of? Did you try
without the "myGDB" part? if your backend is Oracle you don't need that.
Just use sde://myuser:mypassword@anonymised.com:5151/#MyRasterCatalog, where
MyRasterCatalog is the qualified type name of the form user.tablename.
I agree the full url thing is sort of weird but we're tied to it until a
new Coverage API is introduced. The current one, GridCoverage2D seems to
be thought for single files on disk so the url thing for arcsde is a
workaround.
Also, it would be good if you can send me the full stack trace. If
you're not getting one enable verbose exceptions in the geoserver config
and reproduce the error.
Regards,
Gabriel
Velarde Gutierrez, Victor wrote:
> Hello everybody,
>
> I’m writing this email to ask about URL syntax for SDE raster (new
> CoverageStore).
>
> I’m using the recommended way:
>
> sde://user:pass@anonymised.com[:port]/[instance]#raster_table_name
>
> But no matter how I write the slashes ("\" or "/"), I always get the
> message "Invalid url: 'the_Url_I_Wrote'”.
>
> [Note: The plugin and my parameters seems to be ok, as I can get a
> working Feature with them (and use it with WMS / WFS)]
>
> If instead of using the web application I directly edit the
catalog.xml
> file as in here:
>
> <format id = "sdeRasterEjemplo" enabled = "true" namespace =
"ihc" >
>
> <title>sdeRasterEjemplo</title>
>
> <type>ArcSDE Raster</type>
>
> <url>sde://myuser:mypassword@anonymised.com:5151/myGDB#MyRasterCatalog</url>
>
> </format>
>
> and then I try to define a New Coverage with the web app, I get this
> Exception:
>
> The following exception was thrown:
>
> * class java.lang.IllegalArgumentException: ArcSDE Raster URL
must
> be of the form
> sde://user:pass@anonymised.com:port/[dbname]#rasterTableName –
>
> Got sde:\ myuser:mypassword @myHost:5151\myGDB#MyRasterCatalog
>
> It seems that some Java operation inside has changed my slashes to an
> incorrect form!!
>
> I found a similar topic in this list [
>
http://www.nabble.com/What’s-url-syntax-for-SDE-raster-in-GeoServer-1.7.0-beta2-tt19544049.html#a19544049
<http://www.nabble.com/What’s-url-syntax-for-SDE-raster-in-GeoServer-1.7.0-beta2-tt19544049.html#a19544049>
> ]
>
> This is my environment:
>
> - Windows Server 2003 Enterprise Edition SP2
>
> - Geoserver 1.7.4
>
> - Apache Tomcat/6.0.18 (JDK: 1.6.0_13-b03)
>
> - ArcSDE 9.2 SP6
>
> Regards
>
------------------------------------------------------------------------
>
------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY
circumstances! Your
> production scanning environment may not be a perfect world - but
thanks to
> Kodak, there's a perfect scanner to get the job done! With the
NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
>
------------------------------------------------------------------------
>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Stefano Iacovella
-------------------------------
"Objectivity cannot be equated with mental blankness; rather, objectivity resides in recognizing your preferences and then subjecting them to especially harsh scrutiny — and also in a willingness to revise or abandon your theories when the tests fail (as they usually do)." — Stephen Jay Gould
------------------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Gabriel Roldan
OpenGeo - http://opengeo.org
Expert service straight from the developers.
