Hi,
If your data is stored using SDO_GEOMETRY, you can bypass the SDE layer and
have geoserver connect using the Oracle Spatial driver. If it is ST_GEOMETRY or
SDE_BINARY (ESRI specific), you can't.
Of course, all stuff relying on the ESRI metamodel will be ignored. For example
if your data is versioned, you won't see up to date data.
Regards,
Laurent
De : Jonathan Moules [mailto:[email protected]]
Envoyé : samedi 8 juin 2013 15:20
À : Downie, Sonya (DPIPWE)
Cc : [email protected]
Objet : Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0
Hi Sonya,
Just a thought, but why not just connect GeoServer directly to Oracle? We have
both Oracle and ArcSDE and are simply connecting directly to Oracle. I'm not
sure if ArcSDE can offer anything other than another step in the chain for
things to go wrong or a layer to be mis-configured or.... Less is more. :-)
Jonathan
On 5 June 2013 04:04, Downie, Sonya (DPIPWE)
<[email protected]<mailto:[email protected]>> wrote:
Hi there,
I am testing GeoServer 2.3.2 on an XP PC and a Windows7 PC and am having
trouble making a direct connect to ArcSDE.
We have an Oracle 11g database on a Linux server with ArcSDE10. I have
downloaded the appropriate ArcSDE extension for my version of GeoServer and
added the 2 jar files for ArcSDE 10.
I can create a standard connection (3 tier) successfully and publish layers.
However I cannot create a direct connect.
I followed the documentation
(http://docs.geoserver.org/stable/en/user/data/database/arcsde.html#configuring-an-arcsde-vector-data-store-with-direct-connect)
and set my parameters accordingly (I think!)
Server: none
Port: sde:oracle11g:<serverName>
Instance name: none
User: <userName>
Password: <password>
But I get the error:
Error creating data store, check the parameters. Error message: Can't create
connection to none for Session #13[SDE error -66][Error desc=SPECIFIED
PARAMETER VALUE IS INVALID.][Extended desc= ]
I have searched the mailing lists and the web but still no luck. Any help in
which direction I should take will be most appreciated.
Regards,
Sonya
________________________________
CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by
legal professional privilege, and is intended only for the person or persons to
whom it is addressed. If you are not such a person, you are warned that any
disclosure, copying or dissemination of the information is unauthorised. If you
have received the transmission in error, please immediately contact this office
by telephone, fax or email, to inform us of the error and to enable
arrangements to be made for the destruction of the transmission, or its return
at our cost. No liability is accepted for any unauthorised use of the
information contained in this transmission.
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
