topic how to use java connecting to arcsde 10.1( base oracle 11.2g) in ArcGIS JavaScript Maps SDK Questions

how to use java connecting to arcsde 10.1( base oracle 11.2g)

zhangyx — Mon, 17 Dec 2012 10:28:36 GMT

i install oracle 11.2g, then use arcgis gp tool create arcsde geodatabase on oracle 11.2g. how can i use java to connect to arcsde.

how can i write the fallowing code ?

SeConnection connection = null;
connection = new SeConnection(server, instance, database, user, password);

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Mon, 17 Dec 2012 16:32:17 GMT

This would be a way to connect to ArcSDE, but that would not give you full geodatabase
functionality.

What are you trying to accomplish? Writing GIS software (and data) from scratch in Java
probably isn't where you want to start.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

LeoDonahue — Mon, 17 Dec 2012 17:13:20 GMT

Writing GIS software (and data) from scratch in Java
probably isn't where you want to start.

- V

Hey... Let's not single out Java for that... it applies to .NET also.:)

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Mon, 17 Dec 2012 18:23:24 GMT

And 'C', and C++, and Python, and, and COBOL, and FORTRAN, and Ada, and PL/1...

But my point was that an ArcSDE connection does not a GIS make.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

LeoDonahue — Mon, 17 Dec 2012 19:22:29 GMT

I understood your point, I was just trying to save face with those who already slant against Java.

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Tue, 18 Dec 2012 00:09:50 GMT

Sorry, I didn't have time for strategic smilies.

BTW: My last project had me reading shapefiles in Java from scratch, and drifted
into various topological processing functions to detect and correct topology errors
(including correctly handling antemeridian crossing by polygons). Java has improved
in performance from the mid-to-late 90's (when I last used it), to the point that I
no longer have a slant against it! (But I still don't want to code a GIS from scratch
with it.)

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

zhangyx — Tue, 18 Dec 2012 03:33:03 GMT

i use java api for arcsde 10.1

----------------------------------------------------------------------
String server = "10.1.102.171";
String instance = "sde:oracle11g:jinshui";
String database = null;
String user = "sde";
String password = "sde";

SeConnection connection = null;
StringBuilder featureCollection=new StringBuilder("");
connection = new SeConnection(server, instance, database, user, password);

---------------------------------------------------------------------------------

but it throw an error as fallow.

------------------------------------------------------------------------------------
java.lang.UnsatisfiedLinkError: no sdejavautil in java.library.path

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Tue, 18 Dec 2012 11:17:59 GMT

First off, you shouldn't ever connect to an ArcSDE instance as 'sde' (and you shouldn't
ever use 'sde' as the password). The 'sde' user should only be used to administer the
ArcSDE installation, and the password should be closely held to prevent damage to the
database instance. Instead you should create additional tablespaces and users to own
and access the data loaded into those tablespaces.

You also shouldn't start using the ArcSDE API with a Direct Connect in Java. Start with
an application service connection, so you can be sure your class path is correct to find
the ArcSDE jarfiles, then you can move on to the arcane. If you haven't used Java
before, you should spend several weeks working on language basics before attempting
to use a third party API.

Using either of the ArcSDE APIs is an advanced skill, which is much easier to do after
you've been using an instance with ArcGIS for 6-8 months. The learning curve on the
lightly documented ArcSDE API is rather brutal -- expect it to take 3-6 weeks to learn
how to do anything useful (anything that's going to involve a "featureCollection").
Starting with an empty database is the most difficult way to learn the API -- the start-up
cost increases to 3-6 months if you're going to try to create data from scratch.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

DavidDoss — Sat, 18 Jan 2014 07:24:50 GMT

Hi Vince,

I'm facing the same issue when I run the Java program from Linux environment to Arc SDe 10.1. The same code works fine If I run from UNix (Solaris) environment to Arc SDE9.3 or to ArcSDe 10.1 from RAD setup in PC. Purpose of my program is to access a point layer and make deletions based on certain criteria.

I'm using jpe_sdk.jar, icu4j_3_2.jar, jsde_sdk.jar & concurrent.jar. from Arc SDE 9.3. Is there a different set of Jars that I should use for Arc SDE 10.1 ? Below is the error I get.

Exception in thread "main" java.lang.UnsatisfiedLinkError: no sdejavautil in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1738)
        at java.lang.Runtime.loadLibrary0(Runtime.java:823)
        at java.lang.System.loadLibrary(System.java:1028)
        at com.esri.sde.sdk.client.JGsrvr.<clinit>(Unknown Source)
        at com.esri.sde.sdk.client.SeConnection.x(Unknown Source)
        at com.esri.sde.sdk.client.SeConnection.<init>(Unknown Source)
......
The code I use is
SeConnection conn=null;
conn = new SeConnection(dbServer, dbPort, null, dbUser, dbPass);
return true;

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Sat, 18 Jan 2014 11:17:06 GMT

You cannot connect to a 10.1 instance with a 9.3 client. In fact, 9.3 entered
"Retired" support status with the new year.

Esri stopped shipping C/Java API media with the rest of ArcGIS at 10.0. You'd
need to contact Customer Service (or the local distributor equivalent) to get
the SDK media for 10.0-10.2.

The ArcSDE Java API is also now deprecated, and will not exist after 10.2.x.
Given that most databases support some form native geometry, I'd think you
could use straight JDBC for this task.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

LeoDonahue — Fri, 10 Dec 2021 20:32:08 GMT

ArcObjects Java API is still in play for connecting to your database. You just need the undocumented correct combination of connection propertyset properties.

I assume you have the correct version of ArcObjects libraries for doing this. It seems logical that I could not use an ArcObjects 9.3 installation to connect to a newer version of SDE.

Notice the change in SERVERINSTANCE to INSTANCE... that one threw us for a few days. Found help in the forums.

You can adapt this to Oracle... yes?

    private static void connectToSQLServer(){

        try {

            IPropertySet propertySet = new PropertySet();
            propertySet.setProperty("SERVER", "server name");
            propertySet.setProperty("SERVERINSTANCE", "server instance name");
            propertySet.setProperty("DATABASE", "database name");
            propertySet.setProperty("DBCLIENT", "SQLServer");
            propertySet.setProperty("USER", "sql server user name");
            propertySet.setProperty("PASSWORD", "your password");
            //propertySet.setProperty("AUTHENTICATION_MODE", "DBMS");  // Optional.  DBMS is default
            //propertySet.setProperty("AUTHENTICATION_MODE", "OSA");   // Required if using operating sytem authentication

            IWorkspaceFactory workspaceFactory = new SqlWorkspaceFactory();
            IWorkspace workspace = new Workspace(workspaceFactory.open(propertySet, 0));

            IEnumDatasetName dsFeatureClassNames = workspace.getDatasetNames(esriDatasetType.esriDTAny);

            IDatasetName fcName = dsFeatureClassNames.next();
            while (fcName != null){
                System.out.println(fcName.getName());
                fcName = dsFeatureClassNames.next();
            }

        } catch (AutomationException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

Connecting to SDE would be:

            // Create a propertySet that contains the connection information to ArcSDE
            //  In ArcCatalog, the first three values are: server, service, database in the connection properties of the sde connection.
            IPropertySet propertySet = new PropertySet();
            propertySet.setProperty("SERVER", "server name");
            propertySet.setProperty("INSTANCE", "sde:sqlserver:server name");
            propertySet.setProperty("DATABASE", "database name");
            propertySet.setProperty("USER", "user name");
            propertySet.setProperty("PASSWORD", "user password");
            propertySet.setProperty("VERSION", "sde.DEFAULT");  // or whatever you call your version

            // Create a SdeWorkspaceFactory and open it
            IWorkspaceFactory sdeworkspaceFactory = new SdeWorkspaceFactory();
            IWorkspace workspace = new Workspace(sdeworkspaceFactory.open(propertySet, 0));

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Sun, 19 Jan 2014 14:14:54 GMT

ArcObjects Java API is still in play for connecting to your database.

While this is true, installing ArcEngine and the ArcObjects SDK on a Linux box
might be a bit ungainly for what is probably a simple SQL statement.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

LeoDonahue — Sun, 19 Jan 2014 14:33:24 GMT

yeah probably. OP never said they wanted to do something easy after making the connection.

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

MubasharAhmad1 — Mon, 17 Jul 2017 13:19:48 GMT

I am trying to connect via direct connection to PostgreSQL spatial db. Java API version is 10.2 postgre 9.6 jdk 6. It successfully connects to database but when I call conn.getLayers() it says "Error getting layers" arcsde error -37 desc: DBMS TABLE DOES NOT EXIST. I dont know which table it is unable to find.

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

VinceAngelo — Tue, 01 Aug 2017 11:22:34 GMT

PostgreSQL 9.6 is not supported by geodatabases yet, so it can't have an Enterprise geodatabase, so ALL of the geodatabase tables are missing.

- V

Re: how to use java connecting to arcsde 10.1( base oracle 11.2g)

santhoshT — Wed, 15 Dec 2021 08:54:53 GMT