noradle official demo app show how to use http servlet, NDBC, call-out(with socket.io) with oracle PL/SQL.

introduction

"noradle-demo" is originally a part from "noradle" project as "./demo" sub directory,
now, the demo app in noradle is a independent project.

install

npm -g install noradle-demo

cd "project root"

sqlplus "/ as sysdba" @install.sql

or

sqlplus "/ as sysdba" @http://static.noradle.com/repo/noradle-demo/install.sql

In oracle database, configure server_control_t, and run noradle dispatcher to listen for client connection.

npm start [dispatcher_addr:=1522] [http_listen_addr:=8888] to start the demo.

or

run noradle-demo [dispatcher_addr:=1522] [http_listen_addr:=8888]

how to start noradle server, see

Check http://127.0.0.1:8888/demo to see if demo web app is working.

feature exhibited

* get http request info
- for basic http header
- for cookie values
- for querystring
- for form post
- get varchar2, number, date parameters
- for file upload
- for post entity body

* write response info
- basic h.line, h.write API
- x. TAG print API
- m. interpolate template with comma separated string, array or sys_refcursor
- tb. support table print
- tr. support tree structure print, usually ul,li nested tags
- use l(url) to easy specify url the plsql servlet link to
- rs. print sys_refcursor data as compact sql result set that can be easy parsed to javascript objects
- multiple ways of print xml data
- demos that easy utilize css frameworks like bootstrap, pure-css, jquery-mobile
- embed/link coupled-in css
- auto redirect post to _c procedure to a feedback page
- clean previous output in buffer, and regenerating page response

* charset and international support
- support db-charset output or any unicode output, auto conversion
- content negotiation for accept-language

* set response headers that affect the process afterward
- chunked transfer with h.flush, return partial response as quick as possible
- long job that must give partial reponse to client after one step is completed
- response compression like gzip
- response body conversion for text/items and text/resultsets
- specify Content-Type
- specify charset
- file download or attachement
- http redirect immediately or after a delay

* filter support
- before filter used for authentication check, cache data prefetch
- after filter for logging
- login & logoff

* session
- get session data
- set session data

* oracle result-cache
- utilize oracle result cache to cache frequent access data like filter data fetch
- force cache invalidate or update when time is out or then real data is changed

* use NDBC call
- set default parameters
- call with parameters
- use response callback that receive statis,header,entity
- if automatic convert original response from oracle to javascript object
- support text/items, that is lines of data, save line separator is used
- support "text/resultsets*, that is produced from sys_refcursor

* execute call out from oracle (repeated NDBC call)
- call plsql servlet that wait event like pipe new message
- after plsql servlet wait event timeout, repeat call the plsql servlet
- call for oracle call-out message, and send back response to oracle calling service
- use h.begin_msg,h.end_msg to mark output to header/body is for call-out message