2 Replies Latest reply on May 20, 2015 3:49 PM by brian.mcginity

Rest Listener Wish List

brian.mcginity Mar 7, 2015 11:05 AM

With the hopes that this thread might reach the ORDS decision makers, here's my with list. Feel free to add to it:

- remove the requirement to install Apex.

- create two new plsql datatypes: http_request_body_clob and http_request_body_blob. These will contain the raw http request as a clob or as as blob. Or if this is too hard, then create a function which will return the raw request body.

- create an new CGI variable: http_header so we can see the request header from within plsql.

- keep Apache, yes it cannot support websockets, ws:// -- most will have a separate websocket server anyway.

- support Nginx.

1. Re: Rest Listener Wish List

Scott Wesley Mar 10, 2015 8:22 AM (in response to brian.mcginity)

I believe that first point is addressed in v3, currently in EA
ORDS 3.0 New Features

I would like love to see a good white paper describing how to deploy using the Advanced Configuration image
Like Show 0 Likes(0)

Actions
2. Re: Rest Listener Wish List

brian.mcginity May 20, 2015 3:49 PM (in response to Scott Wesley)

Hi Scott, now that mod_plsql is about to be deprecated, I am again testing ORDS v3 / Tomcat without Apex. So far it's working. I am not quite ready for deployment as there are a few details to iron out. Over all ORDS is pretty impressive.

As for putting Apache in front of ORDS as shown in your image, I am pretty sure all that's needed is a ProxyPass in Apache. Add this at the end of the httpd.config file:

ProxyPass /ords http://localhost:8080/ords
ProxyPassReverse /ords http://localhost:8080/ords

Similarly, the same principle holds true with Ngnix. This would be a good place to load balance between a few ORDS instances and SSL terminate.

According to some of the Tomcat bloggers putting Apache in front of Tomcat may not be too necessary. In Tomcat 5.5++ the same native/APR connector exists as Apache's Portable Runtime APR and the performance is similar. http://www.tomcatexpert.com/blog/2010/03/24/myth-or-truth-one-should-always-use-apache-httpd-front-apache-tomcat-improve-perform
Like Show 0 Likes(0)

Actions

Go to original post