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!

ORDS 3.0 - Tomcat modify configuration

partlycloudyJul 3 2015 — edited Jul 7 2015

ORDS 3.0 deployed as a Tomcat webapp. Followed the installation instructions. APEX is accesible via  ORDS. ORDS configdir is d:\apex. Tomcat \webapps\apex.war and \webapps\apex contain the configuration files.

Now if I want to change the configuration to add the following settings

#############################################

apex.excel2collection=true

apex.excel2collection.onecollection=true

apex.excel2collection.name=excel

jdbc.initialLimit=100

jdbc.MinLimit=100

jdbc.MaxLimit=100

##############################################

Question: Where exactly would I add these commands? In the params/ords_params.properties file under d:\apex\apex\ords? Or by manually editing the defaults.xml file? But which file to edit, the one in d:\apex or the one under Tomcat \webaps\apex\...?

I asked these questions on an existing thread already.

If  I understand correctly, we use the commands provided in the ords.war file to configure ORDS/APEX in the designated configdir and it creates files/folders/config files under the configdir. But when we want to deploy as a Tomcat webapp, the instructions ask us to simply copy over the ords.war file to the Tomcat webapps folder, NOT the configdir folder. This would imply that the java -jar ords.war configuration commands not only read the ords.war but also write back to it so it is a standalone file that can be copied as a Tomcat webapp. Is this assumption correct?

Having said that, I am still not sure how to answer my question above.

Can someone from the Oracle ORDS team please clarify how all this works?

Thanks

This post has been answered by Kiran Pawar on Jul 6 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2015
Added on Jul 3 2015
3 comments
1,873 views