ORDS setup

Hi Cortanamo,

Cortanamo wrote:

 

I've followed ORDS setup instructions and attempted to get it running on Big Data VM. Regretfully, althoug AutoREST appears to be working, there's no way I can get the Development connection to work. There is:

1. username, which had to be created with java -jar ords.war user test_developer "SQL Developer",

2. connection goes over http

3. port is the port I used for ORDS setup, 9090

...

Can anyone please let me know how can I find the correct parameters for developer connection to ORDS (it's the Rest development screen in SQL Developer where you should be able to define services)?

You should be able to connect to ORDS using test_developer with configured username and password in Oracle SQL Developer (unless you are giving some wrong information in RESTful Services Connection)

Refer: http://www.thatjeffsmith.com/archive/2016/10/creating-an-oracle-rest-data-services-user-with-the-sql-developer-role/

4. server path, now here documentation is flaky, I have no clue where SQL Developer installed ORDS, so I left it to: /ords

/ords is the correct value for Server Path.

5. Schema/Workspace, which is again totally unclear from the documentation, I've tried /ordstest but no luck.

The value for Schema/Workspace should be the Schema Alias which you give while enabling RESTful Services for that schema (enclosed by /, so if alias is ordstest for your REST enabled schema say HR, then the value for Schema/Workspace should be /ordstest/).

As RESTful Development in Oracle SQL Developer is a Oracle SQL Developer feature, the RESTful Connection using Oracle SQL Developer is described in it's documentation.

Refer: https://docs.oracle.com/database/sql-developer-17.3/RPTUG/sql-developer-dialogs.htm#RPTUG-GUID-877E7B3A-A64A-49D1-AB23-4…

Hope this helps!

Regards,

Kiran

If you installed it from SQL Developer, then that would be a standalone install, so should be SOMETHING similar to this. I'm showing /hr/ because I've enabled HR and did not use a schema alias.

However you can skip all of this and develop your REST services directly from the database connection - there's a REST node in the tree you can use. I have a quick youtube video in that post as well.