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!

URL mapping for APEX from Tomcat

alexoraMay 10 2017

I'm able to access to APEX via ORDS after I've added one extra database. Now trying to add 3rd one: the only difference is that I have a fresh latest APEX version 5.1.1 on this database, no WORKSPACES yet.

I've configured the pool successfully, I DID RUN @apex_rest_config.sql successfully on this 3rd database and I can even see sessions under ORDS_PUBLIC_USER and APEX_LISTENER on this database connected from ORDS server.

Below is my url-mapping.xml

<?xml version="1.0" encoding="UTF-8"?>

<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">

<pool name="db1" base-url=http://apexrep/apex/db1 workspace-id="INTERNAL" updated="2017-05-08T15:28:29.648Z"/>

<pool name="db1" base-url=http://apexrep:8080/apex/db1 workspace-id="WATER" updated="2017-05-08T15:35:28.876Z"/>

<pool name="votr" base-url="http://apexrep:8080/apex/votr/" workspace-id="INTERNAL" updated="2017-05-10T12:45:19.628Z"/>

</pool-config>

So http://apexrep:8080/apex/db1  works just fine.

However http://apexrep:8080/apex/votr  does NOT work.  Could it be related to the empty fresh APEX install ?  But I can access to http://apexrep:8080/apex/db1/apex_admin  Admin page despite providing a different workspace name above.

I did redeployed apex.war into /webapps for Apache Tomcat after I've made the change, the pool for votr is configured properly as I've mentioned I even can see sessions under APEX_LISTENER from this database.

I do use the latest 3.0.9 ORDS version, I've just downloaded:  3.0.9.348.07.16

I've read there was a bug with URL mapping before.

I did tried to enable debug on the screen but looks like I'm getting the same error for votr just like for any other URL's like  http://apexrep:8080/apex/bububub/

404  Not Found 

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

Debug Trace

[TE] url-mapping start: 2017-05-10T13:57:05.972Z duration: 5ms [TE] GET /apex/votr/ start: 2017-05-10T13:57:05.972Z duration: 5ms  

Stack Trace

URLMappingNotFoundException [statusCode=404, reasons=[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]] at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:119) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:83) at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:94) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.filters.Filters.filter(Filters.java:47) at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82) at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:49) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:116) at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 

Alex

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 7 2017
Added on May 10 2017
0 comments
1,136 views