Hi,
I'm new about using ORDS and I try to create any RESTful service but without success.
(Our target is to check the possibility of change all our SOAP web services by RESTful services.)
I make the next statements
1) Install SQL Developer 4.1.3.20 Build MAIN-20.78 on Win7 64bits
2) Tools > REST Data Services > Install
a) (Step1) Use REST .. included with SQL Developer
Select some location for the REST config file
b) (step2) Fill DB connection data
Entry password for ORDS_PUBLIC_USER
NOT check Skip verify ...
Entry data for SYS user
c) (step3) Next
d) (step4) Check Run in standalone ...
Http port 8080
e) (step5) Display Summary and finish
according to the logs, I think that the installation was ok
...
2016-07-22 12:13:06.575:INFO:/ords:main: INFO: Oracle REST Data Services initialized|Oracle REST Data Services version : 3.0.3.351.13.24|Oracle REST Data Services server info: jetty/9.2.z-SNAPSHOT|
2016-07-22 12:13:06.576:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@33b37288{/ords,null,AVAILABLE}
2016-07-22 12:13:06.601:INFO:oejs.ServerConnector:main: Started ServerConnector@70a9f84e{HTTP/1.1}{0.0.0.0:8080}
2016-07-22 12:13:06.601:INFO:oejs.Server:main: Started @18517ms
3) View > REST Data Services > Development
4) Right click > New RESTful services
5) Right click > New module
a) (step1) Module name --> MaholServices, URI Prefix --> MaharWSREST/, Publish ... --> Check
b) (step2) URI Pattern --> Patients/
c) (step3) Source Type --> Query One Row
d) (step4) Display Summary and finish
6) Double click on MaholServices > Patients/ > GET
7) At the SQL Worksheet --> select lib_patient.wsget( '1', null) from dual --> Run --> Entry the connection to run(test) the script
What it is the next step? In which way I "save" the service to check it?
At this moment we want only check the RESTfull services in the browser without any deploy to weblogic for example.
I must to sat that I tried these steps a lot of times (with previous uninstall ).
On some of my tries, I created an admin user "adminlistener" ( java -jar ords.war user adminlistener "Listener Administrator")
Also I performed "Enable REST services" for the DB user in 7) ( I don't sure that it's a must)
Thanks very much on advance