Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[elyoung]

Hi Sonya,

I meet the same trouble with you.

I have an Oracle11g database on a win7 server with ArcSDE10.2. I tried to
create a direct connect in geoserver2.7.6. I also followed the User manual
to set my parameters as you did. 

Have you solved the problem?Please give me some suggestions. 

Many thanks!



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/GeoServer-2-3-2-Direct-Connect-to-ArcSDE-10-0-tp5057976p5315252.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[Downie, Sonya (DPIPWE)]

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.prevo...@sfr.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:jonathanmou...@warwickshire.gov.uk]
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) 
mailto:sonya.dow...@dpipwe.tas.gov.au>> 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:
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
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users


This transmission is inten

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[PREVOSTO, Laurent]

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:jonathanmou...@warwickshire.gov.uk]
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) 
mailto:sonya.dow...@dpipwe.tas.gov.au>> 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:
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
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.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.
--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[Phil Scadden]

> 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. :-)

I believe you can do direct connect if you have Oracle Spatial, but if 
you are using the ArcSDE native method of storing spatial in Oracle, 
then you really need to use ArcSDE. It used to be that arcSDE native was 
faster. Maybe because query was split between database server and 
spatial server but I dont know the in's and outs.

Notice: This email and any attachments are confidential.
If received in error please destroy and immediately notify us.
Do not copy or disclose the contents.


--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[Jonathan Moules]

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)  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:
> 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
> Geoserver-users@lists.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.
--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[cmaul]

Sonya,

please set your instance name. esri_sde is the default - I think. Ask your
DB-Admin.
Other possibility is to define it in the windows services file
(...system32/drivers/etc)
The line looks like that:

esri_sde 5151/tcp   #Corporate spatial desk
database


You have got the jpeXX_sdk.jar,jsdeXX_sdk.jar and icuXX.jar, additionally to
the jars from the Geoserver website?

Cheers

Christian



-


Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/GeoServer-2-3-2-Direct-Connect-to-ArcSDE-10-0-tp5057976p5058267.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[Vince Lotito]

Check your port setting... What you provided is not clear, It is looking for 
something like this... sde:oracle11g:/:prod

Vince

Sent from my iPad

On Jun 5, 2013, at 12:17 AM, "Downie, Sonya (DPIPWE)" 
mailto:sonya.dow...@dpipwe.tas.gov.au>> 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:
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0

[Downie, Sonya (DPIPWE)]

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:
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users