Notifying clients from backend servers in stateless environments like web applications with HTTP protocol is a challenge, here a great bundle where you can achieve this goal in APEX applications.
For a long time I was struggling with having to use a JS library ( https://bashooka.com/coding/10-javascript-libraries-and-tools-to-work-with-pdf/ ) to view pdfs or images from the database, but with no luck because my files are stored in the database as BLOBs, it may seem simple for someone, but was not obvious for me to have a URL for my BLOBs to server the JS libraries. The following post will show how this is done. Preview PDF Uploads in an APEX App (Cross-post)
Here is the history..... in the beginning there was this thing called the "WOW gateway" (Web Oracle Web). It was a cgi-bin that crudely translated a url into a stored procedure call (didn't use bind variables!!! that is why I call it "crude").... It was written originally by Magnus Lonnroth of Sweeden. This became OWA (Oracle Web Agent) in version 1 of OIS (the Oracle Internet Server). It too was a cgi-bin. Later, with version 2 of OWS (OIS -> OWS, the Oracle Web Server), this OWA became a "cartridge" in OWS speak. Like a module for apache but ran in the spyglass mosaic webserver (which is what we used). At that time, some guy named -- oh wait, that was me -- wrote this thing called OWAREPL (historically archived here: http://asktom.oracle.com/~tkyte/owarepl/doc/ ). It greatly extended the capabilities of OWA giving it file upload/download, db authentication and many of the features you take for grant
For production installation, you surely need to have a layer in front (Reverse Proxy) of your ORDS, here are samples of configuration for the most popular web servers 1. Apache Reverse Proxy Configuration using Apache 2. NGINX The Oracle APEX Reverse Proxy Guide using NGINX
Comments
Post a Comment