Hi All,
Thank you all for your help. I have tried everyone’s suggestions but I am still hitting a brick wall.
I have the 3 extra files required to connect to ArcSDE10: jpe_sdk.jar, jsde_sdk.jar and icu4j-3.4.4.jar.
The data is stored as ST_GEOMETRY, so I need to connect as ArcSDE.
The instance name esri_sde is set in my windows services file as:
esri_sde 5151/tcp #ESRI SDE service
I can create a standard 3 tier connection successfully.
Server Name: myserver.work.tas.gov.au
Port: 5151
User:
Pasword:
But we need to be able to create a 2 tier connection (or a direct connect)
as ESRI will be phasing out 3 tier connections down the track.
Server Name: none
Port: sde:oracle11g:/:myserver.work.tas.gov.au
Instance Name: esri_sde (I had tried ‘none’)
User:
Password:
But I keep getting the error message:
Error creating data store, check the parameters.
Error message: Can’t create connection to none for Session #37
[SDE error -66][Error desc=SPECIFIED PARAMETER VALUE IS INVALID.]
[Extended desc= ]
I am quite stumped.
Thanks again for you help,
Regards,
Sonya
···
From: PREVOSTO, Laurent [mailto:laurent.prevosto@anonymised.com…]
Sent: Monday, 10 June 2013 10:22 PM
To: ‘Jonathan Moules’; Downie, Sonya (DPIPWE)
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0
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:jonathanmoules@anonymised.com]
Envoyé : samedi 8 juin 2013 15:20
À : Downie, Sonya (DPIPWE)
Cc : geoserver-users@lists.sourceforge.net
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) <Sonya.Downie@anonymised.com> 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:
Instance name: none
User:
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:
- A cloud service to automate IT design, transition and operations
- Dashboards that offer high-level views of enterprise services
- A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
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.