2 Replies Latest reply on Mar 28, 2017 11:30 AM by mpauls

    404 on custom REST module but not with Auto-REST

    mpauls

      ORDS is Oracle REST Data Services 3.0.9.348.07.16

      Database is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

       

      I have created a Module + Template + GET Handler of Type SQL (SELECT * FROM <table>)

       

      When pointing to http://<myserver>:<port>/ords/<module>/<template> I am getting a 404.

      Auto REST to the same schema works fine.

       

      What am I missing?

       

       

      [TE] url-mapping start: 2017-03-27T15:33:09.144Z duration: 61ms

       

      [TE] GET /ords/aemctest/csv start: 2017-03-27T15:33:09.143Z duration: 85ms

       

      [TE] url-mapping start: 2017-03-27T15:33:09.231Z duration: 39ms

       

       

      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:790)

       

          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:790)

       

          at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:751)

       

          at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:566)

       

          at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:219)

       

          at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)

       

          at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:498)

       

          at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)

       

          at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)

       

          at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

       

          at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)

       

          at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)

       

          at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:98)

       

          at org.eclipse.jetty.server.Server.handle(Server.java:461)

       

          at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:284)

       

          at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)

       

          at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)

       

          at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)

       

          at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)

       

          at java.lang.Thread.run(Thread.java:722)