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)
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.
Hope this helps!
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.
Thanks for the answers guys, I really appreciate your help.
I've found the solution looking at http://www.thatjeffsmith.com/archive/2016/10/creating-an-oracle-rest-data-services-user-with-the-sql-developer-role/
The problem in my case was apparently that I've added the user to the wrong process.
The solution was:
--figure out which ords.war is running the Ords process
ps -ef | grep ords.war
--note down the path to ords war, which in my case was /u01/sqldeveloper/ords/ords.war
--add user to that ords.war and not to some other ords.war which you might have if you did multiple installs into different places and ended up having multiple ords.war files
java -jar /u01/sqldeveloper/ords/ords.war user ords_dev "SQL Developer"
After this I was able to connect to REST Development with:
Connection name: whatever
Username: ords_dev <--what was registered above with java -jar...
/my_test_schema/ <--had to enable this schema for Rest data services