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

419905

Hi,

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:

C:\oracle\DevSuite10g\jdev\bin>.\start_oc4j.bat
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
licationServerLauncher.java:70)
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
</ogc:ServiceException></ogc:ServiceExceptionReport>




What I'm doing wrong!?

Thanks in advance

Dejan

NoelKhan

Dejan,

. . . .Try [url http://geoserver.org] GeoServer. It's free, feature rich, and really easy to setup.

Regards,
Noel

Bkazar-Oracle

Hi,-
For method 2:
Have you loaded the data (See the end of Appendices I)?
What is the version of your database?
Depending on that, you may need patch.
Thanks

419905

Hi,

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?

Thanks

Dejan

405968

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

Bkazar-Oracle

Hi,-
Just sent you email with instructions and SQL scripts.
Please let us know if you need help.
Thanks

405968

Hello,

I am greatly appreciated your reply. I think my corporate might block the email with attachment. Could you please send the materials again to [email protected]? Thanks much.

Regards,
CH

Bkazar-Oracle

Hi CH,-
You are most welcome.
Resent the zip file to your gmail address, too.
Best regards
baris

896898

are those files posted anywhere? if not can I get them sent to [email protected]
thanks

Bkazar-Oracle

Hi,-
could you please send me email
at
baris dot kazar at oracle dot com
Thanks

Bkazar-Oracle

Hi,-
We sent the tutorial and the patch to your email address.
Thanks for your interest
baris