1 2 Previous Next 20 Replies Latest reply on Sep 5, 2013 4:42 AM by Bkazar-Oracle

    How to install/deploy Spatial Web services (WFS & CSW) ?


      I need to use Spatial Web Services (WFS & CSW) for one of our projects, but I cannot find helpfull documentation about how to do it ... MetaLink & Google are no longer my friends...

      The two tutorial/example I found are [Installing and Configuring Spatial Web Service in OC4J|http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/swsinst/swsinstall.htm] and [Hands-on Lab Implementing Oracle Spatial Web services|http://download.oracle.com/otndocs/products/spatial/pdf/oow2010/spatial/spatialoow10_holwk_webservs.pdf], but I'm not able to complete it and to make it functional.

      Here is short description of the steps I did:
      - Install Oracle Database 11g Rel 2 on Windows test machine 32bit
      - Install examples from the Companion CD

      - method 1:
      - Install Developer Suite 10g incl. JDeveloper
      - did all the steps from the tutorial mentioned above incl. adjusting of the config files (server.xml, application.xml etc.)
      - when I tried to start OC4J instance using packaged JDK (java version "1.4.2_06", Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)) , I got following error:

      Starting OC4J with command: ..\..\jdk\bin\java.exe -jar oc4j.jar
      11/06/07 09:22:42 java.lang.UnsupportedClassVersionError: oracle/xml/jaxp/JXDocumentBuilderFactory (Unsupported major.minor version 49.0)
      11/06/07 09:22:42 at com.evermind.server.ApplicationServerLauncher.run(App
      11/06/07 09:22:42 at java.lang.Thread.run(Thread.java:534)

      - method 2:
      - install Web Logic 10.3
      - did all the the steps described in hands-on lab above
      - when I test this services using sample.html file (%ORACLE_HOME%\md\demo\jlib\sdows.ear\sdows.war\sample.html), I'm getting following error:
      GetCapabilities (first link):
      <ogc:ServiceExceptionReport version="1.2.0" xsi:schemaLocation="http://www.opengis.net/ogc http://dtopalovic-nb:7001/sdows/xsds/OGC-exception.xsd"><ogc:ServiceException code="WFS-1042">Exception during processing request</ogc:ServiceException></ogc:ServiceExceptionReport>


      GetCapabilities (second link):
      <ogc:ServiceExceptionReport version="1.2.0" xsi:schemaLocation="http://www.opengis.net/ogc http://dtopalovic-nb:7001/sdows/xsds/OGC-exception.xsd"><ogc:ServiceException code="WFS-1031">Message:Client does not have necessary privileges to execute this request
      Original exception :
      java.sql.SQLSyntaxErrorException: ORA-00942: Table or view not exists

      What I'm doing wrong!?

      Thanks in advance

        1 2 Previous Next