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!

Remove Path Prefix (Workspace) from webservice URLs

krisscoOct 8 2014 — edited Oct 8 2014

I am migrating from Apex Listener 1.1 to ORDS 2+. I want the URLs my clients use to be the same after the upgrade.

One example GET template uses the following structure:

v2/countDetail.json?store={storeid}&dateFrom={dateFrom}&dateThrough={dateThrough}

With the old listener, the URL for this webservice is:

https://my.server/apex/v2/countDetail.....

With the new ORDS the URL for this webservice is:

https://my.server/apex/WORKSPACENAME/v2/countDetail...  (I am aliasing the /apex to /ords using glassfish.)

The inclusion of the workspace name in the URL will cause issues with all of my clients. Is there a way around this?

I have tried changing the Path Prefix in Administration>Manage Service>Set Workspace Preferences, but null is not accepted.

I've even tried manually putting null in there: update apex_040200.wwv_flow_companies set path_prefix = null where short_name = :workspace;

I've tried some other strange things like setting the path prefix to "workspace/.." .

By the way, none of those attempts work.

I'm running Glassfish 3.2, Oracle Database 11g, ORDS 2.5 (I think).

Thank you,

-Kris

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2014
Added on Oct 8 2014
0 comments
900 views