Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to connect as ords developer from SQL developer to Ords

Paul JorstadSep 16 2019 — edited Sep 24 2019

Hello!
I'm trying to set up the connection for ORDS Developer from SQL Developer. But I'm getting

Cannot connect to ORDS APEX_DEV.

HTTP/1.1 403

I'we confirmed that the config dir of the ORDS installation is correct:

D:\apps\Apex\ords-19.1.0.092.1545-appstest\ords-19.1.0.092.1545-appstest>java -jar ords_appstest.war configdir

sep 16, 2019 1:20:38 PM

INFO: The config.dir value is D:\apps\Apex\ords-19.1.0.092.1545-appstest\ords-19.1.0.092.1545-appstest\params

I've created the ords developer user:

D:\apps\Apex\ords-19.1.0.092.1545-appstest\ords-19.1.0.092.1545-appstest>java -jar ords_appstest.war user ords_developer "SQL Developer"

Enter a password for user ords_developer:

Confirm password for user ords_developer:

I have rest-enabled the schema, and det the "schema alias" to "data" (and checked "Enable schema")

ords.png

The ords and apex is up and running... But I get:

ords2.png

I can't find any logs for the root cause of this error..

Any ideas on why it fails?

Another question: Why is it possible to create the Ords users only in stand-alone mode when installing ords through the wizard in SQL Developer?

This post has been answered by thatJeffSmith-Oracle on Sep 16 2019
Jump to Answer
Comments
Post Details
Added on Sep 16 2019
4 comments
711 views