ORDS REST error after new installation

July 1, 2017 at 4:50 pm | Posted in Oracle Developement | Leave a comment

After installing and configuring ORDS 3.0.10, I noticed that APEX ran fine, but when testing the sample HR REST module I received the following error:

URI: http://myserver:8080/ords/cmr/hr/empinfo/

Error:
The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured

resterror

The reason was that the table ords_metadata.apex_pool_config was missing the column pool_name. To fix this, I simply had to run the ORDS validation:

java -jar ords.war validate

This added the missing column, and the error went away.

I found the answer to this on OTN.

Advertisements

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Entries and comments feeds.

%d bloggers like this: