Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Document how to reference REST enabled SQL #5

Open
martindsouza opened this issue May 24, 2018 · 0 comments
Open

Document how to reference REST enabled SQL #5

martindsouza opened this issue May 24, 2018 · 0 comments

Comments

@martindsouza
Copy link
Owner

martindsouza commented May 24, 2018

This is dependant on updates to martindsouza/docker-oracle-ords#10

Key here is that the URL that you use is from within the Docker network. Ex: my current REST enabled SQL (while referencing from my laptop) is: http://localhost:32181/ords/giffy/_/sql but when defining this as a REST Enabled SQL End Point in APEX 18.1 on a Docker network it's: http://ords-1810:8080/ords/giffy where ords-1810 is the name of my ORDS docker container and 8080 is it's native port

Note: I know it doesn't make sense for the DB to "query itself" over REST for performance reasons. Usecases are:

  • Testing out the REST enabled SQL
    • For both APEX data source and also from curl (or other RESTful apps)
  • Connecting to other PDBs
  • Perhaps even connecting to other Oracle DBs on the same Docker network (low probability given the purpose of this project)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant