Connecting to Non-default Database Instance in SQL Developer for REST Development Fails with HTTP 404
Last updated on APRIL 11, 2018
Applies to:Oracle REST Data Services - Version 3.0.9 and later
Information in this document applies to any platform.
A REST enabled has been created in two different database instances. The intent is to create ORDS based REST services and run Application Express (APEX) for both of these instances.
It is possible to connect to the schema in the default database (defined in defaults.xml) when running APEX and when connecting using SQL Developer.
ORDS based REST services can be accessed, as well.
The non-default database instance and schema can be reached via the APEX URL:
However, it is not possible to connect to the non-default (newdb) via SQL Developer's Rest Development interface.
When attempting to connect through SQL Developer, the error shown is:
HTTP 1.1/ 404 not found.
Oracle REST Data Services: 22.214.171.1248.07.16
Sql Developer Version: 126.96.36.199.089
Sql Developer Build: 17.089.1709
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms