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!

Inexperienced w/ORDS Questions

brian.mcginityFeb 8 2021 — edited Feb 9 2021

I have a mod_plsql web app running the old Oracle HTTP Server. It is pretty active. Apache will keep alive more than 600 active connections and it's growing quickly. I'd like to replace OHS with ORDS / Tomcat. I hope it can handle the load. I have experimented with ORDS back when it was in the 3.xx version and ran into a handful of issues some of which I know were resoled. I'm going to take another shot and just downloaded v20.4.1. I have a handful of setup questions.
Question 1:
What is best way to change the url so it can go to http://localhost/user1 instead of http://localhost/ords? I do not want to use something like http://localhost/ords/user1.
And is it possible to setup multiple users such as http://localhost/user1 http://localhost/user2 http://localhost/user3?

Question 2:
Once it is deployed into Tomcat, if I need to change a config file, can I just make the change and then restart Tomcat? Or do I need to rebuilt the .war file and then redeploy it to Tomcat?

Question 3:
I read the documentation as to how to deploy to Tomcat and it says to copy the war file into the weapps directory. It did not mention setting standalone.mode=false or anything. The odd thing is when I look at ords_params.properties file, db.hostname, db.port, db.servicename and db.sid are empty. Is this file still being used? ORDS does run in standalone mode.

Comments
Post Details
Added on Feb 8 2021
2 comments
195 views