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>
or 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
I loaded the data using sql scripts in the wsclient.jar (src/sql/wfsrelmd.sql & wfsdocmd.sql & cswmd.sql).
My database is 11g Rel 2 on Windows.
Where can I find this patch you mentioned?
Could you guys please post or send me the sql scripts mentioned in the APPENDICES IV: 00_create_user_data_index.sql, 05_0_configure_users.sql, 05_1_procedure_grant_rights.sql and 05-2_grant_rights.sql? Thank you much
I want to deploy wfs using method 1:
I install Oracle Database 11g Rel 2 on Windows test machine 64bit,but I can't download cd ,and JDeveloper can't be installed successfully, I want to know you use what kind of JDeveloper. Can you send your data and material to my email address?
I want to deploy wfs using method 1:
I install Oracle Database 11g Rel 2 on Windows test machine 64bit,but I can't download cd ,and JDeveloper can't be installed successfully, I want to know you use what kind of JDeveloper. Can you send your the zip file , data and material to my email address? email@example.com
Q: Have you tried GeoServer as suggested?
Just download the stand-alone version (windows installer) to give it a try. It is easy to configure with a decent GUI tool, has good performance, and is well supported. We have now used it in production for over five years with good results.
You will need the base GeoServer package, plus the Oracle data store plug-in. "Installing" the plug-in consists of copying a couple files into a directory, a piece of cake compared to what you have been up against!