ORDS Standalone and URI Rewrites

My last post How to add an NCSA style Access Log to ORDS Standalone explained what the ORDS standalone is and that is based on Eclipse Jetty.  Jetty offers far more than ORDS exposed in it's standalone.  There's a long list of all the features and configuration options listed in the... [Read More]

DB Auditing and ORDS

There seems to be some confusion around how ORDS works with it's connection pooling yet running the REST call as the specified schema.The connection poolConsider a 50 PDB env and concurrent users per PDB running some REST stuff.  Using a connection pool per PDB would be 50 connection pools.  Then... [Read More]

How to add an NCSA style Access Log to ORDS Standalone

What ORDS Standalone is     ORDS Standalone webserver which is Eclipse Jetty, https://eclipse.org/jetty/ .  For the standalone, ORDS sends output to STDOUT, it runs on the command line.  That means there's nothing like a control commands like startup, shutdown,status nor log files, access logs.  It's bare bones intentionally to get up... [Read More]

SQLcl custom Input prompt and validations

Another quick twitter inspired blog post inspired by the SQLcl account itself.Asked and answered: Do you support the ACCEPT command? YES. pic.twitter.com/NchmQ6Eegs— SQLcl (@oraclesqlcl) November 29, 2016ACCEPT is a great way to get input but validation has to happen elsewhere as there's no hooks to do something like validate a... [Read More]
Tags: sqlcl

ECMA Script 6 / Nashorn / Java 9 and SQLcl

This blog post brought to you by the letter M as in Martin . Follow @martindsouza . He asked me on twitter if SQLcl via Nashorn could use ECMA Script 6 features yet.  The answer is yes.  So, for the brave that want to try out the latest greatest ECMA Script 6... [Read More]
Tags: sqlcl