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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connection string for Oracle ORDS docker container

SorenStirnerNov 4 2022

Hello, I'm stuck trying to run the ORDS container over the Oracle-db container. I made the connection string txt file wich is mandatory, the docker engine can read it but this is the output:
Cannot connect to database please validate CONN_STRING has below shape: user/password@hostname:port/service_name
my connection string:
CONN_STRING=sys/#mypwd#@172.xx.0.xx:1521/ORCLCDB
My oracle-db container is up and running, can connect to it in SQL Developer (user and pwd are ok, service_name and port are ok).
Anything else I can try?
Both oracle-db container and ords container are set to run in the same docker network (so network ok) I tried with the container ip (the one 170.xx.0.xx like from) as hostname, no luck.

Comments

EdStevens

This really has nothing to do with SQL Developer (the subject of this forum). It is a much better fit in SQL & PL/SQL.
And just as a side comment, storing 'age' as data is a flawed design. The 'age' of everyone and every thing is increasing by the day, if not by the second. What is your plan to keep 'age' current? Better to store 'date of birth' and the calculate 'age' when needed at run-time.

User_H3J7U

The 'age' of everyone and every thing is increasing by the day, if not by the second.
Sometimes the age stops increasing.
изображение.png

EdStevens

Pour me one!
Of course, that's not actually the age, but the amount of time it was 'aged' in the barrel before bottling.

1 - 3

Post Details

Added on Nov 4 2022
12 comments
4,353 views