Latest Contributions by SachinKanaujia

ST_GEOMETRY is ESRI's format while SDO_GEOMETRY is Oracle's so if you want pure SQL then you would need to goto SDO_GEOMETRY. If you want to use ST_GEOMETRY then you can look at ArcObjects Java API or use Geoprocessing (calling it from java). I found the following in the deprecation plan of ArcGIS 10.2: In our recent Java/Oracle project, we want to write/read Features to an Oracle DB, which uses ST_GEOMETRY instead of Oracle's SDO_GEOMETRY. So my questions is: 1. Is it a bad idea to use the Java SDE API when starting from scratch? 2. If SQL is the alternative - how can I do this? Shouldn't there be JDBC Support for ST_GEOMETRY in Oracle? I could not find anything like that. 3. If there is no JDBC Support - isn't the SDE API the only path to go currently? I don't see "many other options". ... View more

Hi, I am not sure if I understood your question completely on the "drawing a similar polygon on my map using the javascript API". What is the spatial reference you are using? What data are you referencing in your clip and ship? ... View more

Hi Mody, What language are you trying to setup. Can you confirm the software version and patch number? I hope you have applied the language patch? ... View more

Oracle provides some facilities. I don't know if you have already looked at that. Worth trying out http://docs.oracle.com/cd/E11882_01/java.112/e16548/dbchgnf.htm Other custom approaches could also be designed. Do you have any update date field or any unique identifier? ... View more

Does you application have to be real-time or near real time? As you say notification? Is it like a "Push notification" where you sending the notification from the server to the client as soon as they arrive or a "Pull notification" where client queries and gets the information? If its the latter then you are better off writing a view or a materilized view over the database to get the information. You can either poll it or refresh as n when the requests are received. Some more details can help in being more specific? ... View more

@Mitch You are trying to connect using Operating System Authentication, so I hope you already have your database configured to use Operating system authentication else you need to configure it. 1) Try to see if normal SQL Server Authentication is working as per the code provided above by Leo Donahue. This essentially means you are able to make connections using arcobjects code.             IPropertySet propertySet = new PropertySet();             propertySet.setProperty("SERVER", "servername");             propertySet.setProperty("INSTANCE", "sde:sqlserver:SERVERNAME");             propertySet.setProperty("DATABASE", "databasename");             propertySet.setProperty("USER", "databaseUser");             propertySet.setProperty("PASSWORD", "databaseUserpassword");             // Create a SdeWorkspaceFactory and open it             IWorkspaceFactory sdeworkspaceFactory = new SdeWorkspaceFactory();             IWorkspace workspace = new Workspace(sdeworkspaceFactory.open(propertySet, 0)); 2) A good way to test OSA is to first use some kind of a client or sql command window to connect in OS Authentication mode. Then try using the code you have. ... View more

Make sure that the required environment variables are set correctly before launching the jar. Also <Arcgishome>/bin is in your PATH ... View more

Look at the input and output locations printed. Instead of using temp gp package locations its better you use some like a C:\ for your input and output. ... View more

Can you provide the Initialization code you are using? It appears you are not binding your Arcobjects environment correctly to the available product on your machine. ... View more

In an ArcMap you can always take the input from the dataset added to ArcMap. In the geoprocessing environment, you need to either provide the complete path to the input data or else use input parameters to pass GPRecordset for features. For now you need to change your script to provide the complete path to the file. Example, I need to copy xyz.shp. I assume you already had the scratch.gdb setup. You would need to create your gpk again. I hope this helps !!! # Import arcpy module import arcpy # Local variables: TestPolygon = "C:\\Projects\\TestPolygon\xyz.shp" TestPolygonCopy = "C:\\Projects\\Geospatial-Developmental\\TestNoGUI\\TestNoGUI\\Scratch.gdb\\TestPolygonCopy" # Process: Copy Features arcpy.CopyFeatures_management(TestPolygon, TestPolygonCopy, "", "0", "0", "0") ... View more

Looks like it is still picking up the 64 bit JRE. Can you check and make sure you run it on a 32 bit JRE ... View more

Yes you need to use a 32 bit version of java. Here is the System requirement. http://resources.arcgis.com/content/arcgissdks/10.0/system-requirements If you are developing some console based jobs etc then this should be sufficient but if there is something that requires a UI component then you need to use ArcGIS Engine. ... View more

Thats a bit strange. All I can suggest you is to print some environment variables from within your script (running as shortcut) which could make the difference, like JAVA_HOME, PATH, ARCGIS related path. Also there is a subtle difference in implementation of tools in 10.1 as compared to previous versions but it should have consistently failed either way. Try the following 1) Set all the required paths 2) source init_java.sh or init_java.csh as the shell you are using before launching your java program. Can you tell me how you are doing any of the tools implementation?? ... View more

Are you able to execute the same insert query from a sql prompt or sql editor and not here? Its always better to have a schema name qualification for the tables to be sure that they are modified correctly. ... View more