(Hope someone can help me on this, spent a good chunk of the weekend trying to get this to work.)
I installed and deployed ORDS 3.0.1 using Sql Developer 4.1.1. It's working with my APEX 4.2.5.00.08 on DB 12.1.02 deployed on Weblogic Server 12.1.3 (zip distro from otn) all running on my Windows 10 box.
Now I want to add the ability to run a simple "hello world" mod_plsql procedure. I simply can not get it to work. Here's what I did (as best I remember):
create user ken identified by somepassword;
grant create session, resource to ken;
create or replace procedure test
I can run the procedure from SQL Developer and get the expected output.
In SQL Dev ORDS Administration, I created a new Database Setting (apex) is already there called ken:
JDBC: default settings
URL Mapping: Rule_type: Request Path, Routing Rule: /ken, Schema for RESTful services: KEN
ORDS_PUBLIC_USER: entered password for that user
PL/SQL Gateway User: KEN
APEX REST Users: left both passwords blank, ORDS documentation seems to indicate they are not necessary for non APEX usage.
Weblogic command window provides the following error message:
INFO: Updated configurations: defaults
Aug 10, 2015 8:29:50 AM oracle.dbtools.url.mapping.file.FileURLMappings process
WARNING: Could not find any matching database target for: ken,KEN
<Aug 10, 2015 8:29:50 AM EDT> <Warning> <Default> <BEA-000000> <Could not find any matching database target for: ken,KEN>
I'm figuring something is wrong with the url-mapping.xml:
<?xml version="1.0" encoding="UTF-8"?>
<pool base-path="/ken" name="ken" workspace-id="KEN"/>
I tried configuring it with the java command line syntax:
d:\Oracle\sqldeveloper\ords>java -jar ords.war map-url --schema-name KEN --type base-path /ken ken
<Aug 10, 2015 8:56:58 AM EDT> <Error> <Default> <BEA-000000> <The pool named: ken_pu is not correctly configured, error: ORA-01017: invalid username/password; logon denied
I've tried URL Path mapping http://alluvion4:7001/ords/ken from SQL Dev
NotFoundException [statusCode=404, reasons=]
My workaround so far is to copy the ords.war, rename it and redeploy it using SQL Dev, set the PL/SQL Gateway user to my target schema ken, skip the APEX restful services configuration and deploy to weblogic. That works but I would like it to work from a single deployment and I would like to understand the url-mapping options (what is required and what is not for this configuration).
Any help is greatly appreciated.