Oracle Magazine, Jan/Feb 2018
Database Developer REST article will show you how to configure Oracle REST Data Services for this feature and demonstrate a REST enabled SQL scenario INSTALLATION AND CONFIGURATION You can download version 174 of Oracle REST Data Services from Oracle Technology Network Installation of this Oracle REST Data Services version is no different from earlier versions however the REST enabled SQL feature is not enabled by default The REST enabled SQL feature can be enabled by default for all connection pools servicing Oracle Database instances or it can be enabled for a particular database To enable it for all databases add the following line to the DEFAULTS XML file ORACLE MAGAZINE JANUARY FEBRUARY 2018 106 entry key restEnabledSql active true entry Otherwise add the line above to the appropriate XYZ_ PU XML connection pool configuration file If your environment includes multiple databases configured for Oracle REST Data Services it is recommended that you enable REST enabled SQL only on connection pools where the feature is required Restart Oracle REST Data Services and the new REST enabled SQL endpoint _ sql will then be available on REST enabled schemas SECURITY REST enabled SQL supports two security schemes web server authentication and database user authentication Web server authentication allows SQL workloads to be executed on any REST enabled schema for a web server user that has been granted the SQL Developer role
You must have JavaScript enabled to view digital editions.