How do I deploy an Oracle Web Service to our Oracle 10g Server?
I am completely new to java and web services so please bare with me.
I have been asked to develop a simple web service to extract some data from an existing Oracle 10g database and make it available to an off-the-shelf service oriented application (SOA), which I also no nothing about, so quite a learning curve ;-)
I have downloaded and installed the latest 10g version of jdeveloper and have used the following document to create a sample web service:
http://www.oracle.com/technology/obe/obe1013jdev/10131/wsfromplsqlpackage/devwsfrom%20plsql.htm
The pl/sql package isn't quite what I need, but I can resolve this later.
I have successfully created the sample web service and run it on my PC through OC4J. I now want to deploy it to our Oracle 10g Application Server, which runs on a HP-UX, unix machine.
We have a specific DBA team who support the Oracle databases and application servers, however, no one in the team has experience of working with web services.
Can you please point me in the direction of some detailed documentation describing how to do the following:
- Configure Oracle Application Server (assuming this is what is required to run web services). This is currently used to run Oracle Webforms and Oracle Reports.
- Move the web services code that I developed in JDeveloper to the Oracle Server machine so that it can be run (by Oracle Application Server?).
I have been asked to develop a simple web service to extract some data from an existing Oracle 10g database and make it available to an off-the-shelf service oriented application (SOA), which I also no nothing about, so quite a learning curve ;-)
I have downloaded and installed the latest 10g version of jdeveloper and have used the following document to create a sample web service:
http://www.oracle.com/technology/obe/obe1013jdev/10131/wsfromplsqlpackage/devwsfrom%20plsql.htm
The pl/sql package isn't quite what I need, but I can resolve this later.
I have successfully created the sample web service and run it on my PC through OC4J. I now want to deploy it to our Oracle 10g Application Server, which runs on a HP-UX, unix machine.
We have a specific DBA team who support the Oracle databases and application servers, however, no one in the team has experience of working with web services.
Can you please point me in the direction of some detailed documentation describing how to do the following:
- Configure Oracle Application Server (assuming this is what is required to run web services). This is currently used to run Oracle Webforms and Oracle Reports.
- Move the web services code that I developed in JDeveloper to the Oracle Server machine so that it can be run (by Oracle Application Server?).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
After lots of time and many problems I was able to deploy the web service through Oracle's Application Server Control, part of Enterprise Manager 10g.
Now I need to figure out how to test and call it and I've raised another question:
https://www.experts-exchange.com/questions/26382098/How-to-test-an-Oracle-web-service.html
Now I need to figure out how to test and call it and I've raised another question:
https://www.experts-exchange.com/questions/26382098/How-to-test-an-Oracle-web-service.html
ASKER
Thanks for the pointer. I used Enterprise Manager Server Admin Console to deploy the web service.
this is the normal process when we do the same thing in .net.
i deploy a webservice on a web server and from the config file change the setting for the database to connect to the right server.
i hope this way your application should also work so that the Database server and webserver or Oracle IAS Application server will be decoupled.