This discussion is archived
1 Reply Latest reply: Jan 1, 2013 11:14 PM by Nattu RSS

RESTful web services throws page not found error in apex listener

Nattu Explorer
Currently Being Moderated

I have configured Apex Listener 2.0 with Apex 4.2 and Oracle 11g Express Edition after sorting out the issues as discussed in the thread Apex Listener Configuration Issue.

After setting everything up in the listener thro SQL Developer, the TEST button appears on the RESTful Service>Resource Template> Resource Handler Page in Apex SQL Workshop. However, if I click the button it says 404 Page not found error.
WebException [statusCode=404]
     at oracle.dbtools.rt.web.WebException.webException(
     at oracle.dbtools.rt.web.WebException.notFound(
     at oracle.dbtools.rt.web.RequestDispatchers.dispatch(
     at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(
     at oracle.dbtools.rt.web.HttpEndpointBase.service(
     at javax.servlet.http.HttpServlet.service(
     at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(
     at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(
     at com.sun.grizzly.http.servlet.ServletAdapter.doService(
     at oracle.dbtools.standalone.SecureServletAdapter.doService(
     at com.sun.grizzly.http.servlet.ServletAdapter.service(
     at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(
     at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(
     at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(
     at com.sun.grizzly.http.ProcessorTask.invokeAdapter(
     at com.sun.grizzly.http.ProcessorTask.doProcess(
     at com.sun.grizzly.http.ProcessorTask.process(
     at com.sun.grizzly.http.DefaultProtocolFilter.execute(
     at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(
     at com.sun.grizzly.DefaultProtocolChain.execute(
     at com.sun.grizzly.DefaultProtocolChain.execute(
     at com.sun.grizzly.http.HttpProtocolChain.execute(
     at com.sun.grizzly.ProtocolChainContextTask.doCall(
     at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(
     at com.sun.grizzly.util.AbstractThreadPool$
     at Source)
The URL is http://localhost:8585/apex/natarajan/hr/empinfo where apex is the default data base, natarajan is my workspace name, hr is the RESTful service module and empinfo is the URI template. Note, it is the url of the sample web service created by Oracle itself. I am not sure what went wrong with this.

I followed the steps in the SQL Developer (version 3.2) User Guide for administrating RESTful services
, in there it is told in the section to Enable RESTful Services, but I couldn't find an option in the SQL Developer window under the Listener>Database Settings>apex>Connections>RESTful Connection. I was able to give password for APEX_LISTENER and APEX_REST_PUBLIC_USER and the listener started successfully.

Will highly appreciate your help.



Edited by: Nattu on Jan 2, 2013 3:29 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points