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

thatJeffSmith-Oracle
Answer

We recommend you use the REST Services in your rest enabled schema on the connection tree for managing/building your rest services.

That user you are creating is a jetty user you can do basic authentication with ...we recommend you use oath2 instead

Marked as Answer by Paul Jorstad · Sep 27 2020
Paul Jorstad

ok, as long as I don't need to create that jetty user and can use the methods in the connection tree for developing, I'm fine :-) It's just that many articles around referred to that method of creting that jetty user and use that for development.

thatJeffSmith-Oracle

Be careful of what you read on the Internet, even (or especially) if it's mine.

Paul Jorstad

Haha, I'll keep an extra critical eye on your articles ;-)

1 - 4

Post Details

Added on Sep 16 2019
4 comments
693 views