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