ORDS, SODA & JSON in the Database

Hello,

I have a working standalone Application Express Listener 1.1 that serves over HTTP just great, but does not seem to serve OK over AJP.

The only change I have made to the Application Express Listener is an upgrade of the images directory, to match an upgrade we did on the database side. Before performing this upgrade, the AJP was working fine.

When I try and use AJP, I get this in the java output:

INFO: Starting: /opt/local/apxapp/apex/apex.war
*See: 'java -jar apex.war --help' for full range of configuration options*
INFO: Extracting to: /var/tmp/apex
INFO: Using classpath: file:/var/tmp/apex/apex/____embedded/start.jar:file:/var/tmp/apex/apex/WEB-INF/lib/je-4.0.103.jar:file:/var/tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/var/tmp/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/var/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/var/tmp/apex/apex/WEB-INF/lib/ojmisc.jar:file:/var/tmp/apex/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/var/tmp/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:file:/var/tmp/apex/apex/WEB-INF/lib/ucp.jar:file:/var/tmp/apex/apex/WEB-INF/lib/apex.jar:
INFO: Starting Embedded Web Container in: /var/tmp/apex
Jul 16, 2012 10:46:19 AM ____bootstrap.Deployer start
INFO: AJP Listener on port 8009 enabled, HTTP listener is disabled.
Jul 16, 2012 10:46:19 AM ____bootstrap.Deployer deploy
INFO: Will deploy application path=/var/tmp/apex/apex/WEB-INF/web.xml
Jul 16, 2012 10:46:20 AM ____bootstrap.Deployer deploy
INFO: deployed application path=/var/tmp/apex/apex/WEB-INF/web.xml
Jul 16, 2012 10:46:20 AM com.sun.grizzly.http.jk.server.JkMain init
INFO: Can't find home, jk2.properties not loaded
Jul 16, 2012 10:46:20 AM com.sun.grizzly.http.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jul 16, 2012 10:46:20 AM com.sun.grizzly.http.jk.server.JkMain start
INFO: Jk running ID=0 time=3/22 config=null
Jul 16, 2012 10:47:40 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
oracle.dbtools.rt.service.ServiceLocatorException: There are no services defined
at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:91)
at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:74)
at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:85)
at oracle.dbtools.rt.web.HttpEndpointBase.dispatchers(HttpEndpointBase.java:138)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.sun.grizzly.http.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:195)
at com.sun.grizzly.http.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:139)
at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:376)
at ____bootstrap.SecureServletAdapter.doService(SecureServletAdapter.java:72)
at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:324)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:180)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.http.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:237)
at com.sun.grizzly.http.jk.common.HandlerRequest.invoke(HandlerRequest.java:330)
at com.sun.grizzly.http.jk.common.ChannelSocket.invoke(ChannelSocket.java:816)
at com.sun.grizzly.http.jk.common.ChannelSocket.processConnection(ChannelSocket.java:742)
at com.sun.grizzly.http.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:942)
at com.sun.grizzly.http.jk.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:662)

Here is how I am starting with AJP enabled:

*{apex_dir}/java/bin/java -Dapex.ajp=8009 -jar ${apex_dir}/apex.war > ${apex_dir}/apex.out*

Here is how I've configured our Apache web server to pass through AJP requests:


ProxyPreserveHost On
ProxyPass /apex ajp://apexhost:8009/apex
ProxyPassReverse /apex ajp://apexhost:8009/apex
ProxyPass /i ajp://apexhost:8009/i
ProxyPassReverse /i ajp://apexhost:8009/i