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!

misc.defaultPage within database config xml does not override defaults.xml?

2819766Aug 26 2014 — edited Aug 30 2014

Hi, we are attempting to move our apex 2.0.1 applications from a OAS webserver to WebLogic 12.1.2 with ORDS 2.0.9.

I'd like to create url mappings that point to different DB config files, which then have different default page for each.

For example:

http://<host>:<port>/ords/ --> default page set to apex

http://<host><port>/ords/app1 --> default page set to f?p=100

The problem is, no matter what I put for misc.defaultPage within the invidividual database config xml files (e.g. app1.xml), the misc.defaultPage from the defaults.xml is used instead.

For example:

../ords/defaults.xml --> misc.defaultPage=apex

http://<host>:<port>/ords/ --> goes to apex (correct)

../ords/conf/app1.xml --> misc.defaultPage=f?p=100

http://<host><port>/ords/app1 --> goes to apex (incorrect!)

Anyone else see this before?

This is the procedure I followed (from http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/config.htm#AELIG7191):

1. Set up ords.war using command: java -jar ords.war
1. a. Add additional database connections: java -jar ords.war setup --database app1

1. b. Create URL mappings to new DB connection: java –jar ords.war map-url --type base-path app1 app1

1. c. Modify ords/conf/app1.xml and update the misc.defaultPage setting to point to application path (e.g. f?p=100)
2. Create i.war: java -jar ords.war static <path_to_apex_files>
3. Deploy ords.war and i.war to weblogic server.
4. Test ords setup:
4. a. http://<wlserver>:<wlport>/ords/f?p=100 --> good
4. b. http://<wlserver>:<wlport>/ords --> forwards to apex (f?p=4550) good.

4. c. http://<wlserver>:<wlport>/ords/app1/f?p=100 --> good
4. d. http://<wlserver>:<wlport>/ords/app1 -->forwards to apex (f?p=4550) --> WRONG

Details: We are running ords 2.0.9 on WebLogic 12.1.2 on a RHEL5 x86-64bit server.

Message was edited by: user1015961 Corrected a typo in my example

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2014
Added on Aug 26 2014
1 comment
1,928 views